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.

Permissions:
Make sure SQL Server Service account has permissions for
Instant File Initializtion
and Lock Pages in Memory ( Probably its good to do it )
http://technet.microsoft.com/en-us/library/ms175935(v=sql.105).aspx
https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

Instant File Initialization Article :

http://blogs.msdn.com/b/sql_pfe_blog/archive/2009/12/23/how-and-why-to-enable-instant-file-initialization.aspx

Power Plan :
Make it High Performance and make sure its set that way.
http://blogs.msdn.com/b/cindygross/archive/2011/03/09/power-saving-options-on-sql-server.aspx

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

MAXDOP and Cost Threshold for Parallelism Configuration:

http://ramblingsofraju.com/technology/more-cpus-in-sql-server-does-it-help-or-hurt-maxdop/

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 : http://msdn.microsoft.com/en-us/library/ms175527.aspx

****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 *

*