Checklist for SQL Server Installation

Feature Selection :
We don’t want to install all the features. Identify the features needed and install only those features.

Model Database Properties :
Figure out all the Model database Properties and configure them Correctly.

File Layout :
Make sure Data and log files are stored appropriately.

Make sure SQL Server Service account has permissions for
Instant File Initializtion
and Lock Pages in Memory ( Probably its good to do it )

Instant File Initialization Article :

Power Plan :
Make it High Performance and make sure its set that way.

TempDB :
Create number of files appropriate to number of Cores or CPUs Available on the Machine.

MAXDOP and Cost Threshold for Parallelism Configuration:

Max Memory Configuration

Script to Create Additional TempDB Files

Output from the Query :
— Instance name: DEVSERVER\DEV2008 ;

/* Version: Microsoft SQL Server 2008 (SP3) – 10.0.5500.0 (X64)
Sep 21 2011 22:45:45
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)
— TOTAL numbers of CPU cores on server :16
— Number of CPU cores Configured for usage by instance :16
— Current Number of Tempdb datafiles :1


WARNING: Some Existing datafile(s) do NOT have the same size as new ones.

It’s recommended if ALL datafiles have same size for optimal proportional-fill performance.Use ALTER DATABASE and DBCC SHRINKFILE to resize files

Optimizing tempdb Performance :

****Proposed New Tempdb Datafiles, PLEASE REVIEW CODE BEFORE RUNNIG *****/


Query to See Te How Writes are distributed across Files

Leave a Reply

Your email address will not be published. Required fields are marked *