Some suggested sql server 2008 r2 instance configuration settings

Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level settings that you should consider changing from their default values. These include Max Server Memory, optimize for ad-hoc workloads, default backup compression, max degree of parallelism, and the number of TempDB data files for the SQL Server instance.

What is the basic functions for master, msdb, model, tempdb databases?

The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
The model is essentially a template database used in the creation of any new user database created in the instance.

install SQL 2005 on windows 2008 or R2 server

install on windows 2008 ( read below for R2 )

install KB950636 before installing SQL 2005

install SQL 2005, after the install is completed. install SP3 for SQL 2005

install on windows 2008 R2

Category Archives: MS SQL

Some suggested sql server 2008 r2 instance configuration settings

What is the basic functions for master, msdb, model, tempdb databases?

install SQL 2005 on windows 2008 or R2 server

Categories