SQL Server Tacklebox- P5: This book, as with almost all books, started out as an idea. I wanted to accumulate together those scripts and tools that I have built over the years so that DBAs could sort through them and perhaps adapt them for their own circumstances. | 1 Eating SQL Server installations for breakfast you do not enable it for 32-bit installations of SQL Server on Windows 2003 Enterprise you will not use the memory that you may think you should be using SQL Server will live within the 2G memory range to which 32-bit applications are generally relegated. However there are also options that you will not want to change. Two of these options are priority boost and lightweight pooling . Changes to these options are typically done only with affirmation from Microsoft Support that it will help and not hinder your environment. In general please do not change a configuration unless you have thoroughly tested it. The automated SQL Server configuration script So what configuration changes can we automate There are many and the base script provided in the next section can be extended to support your particular environment. The options fall into three categories Server-level changes you can make with sp_configure Database-level changes you can make with sp_dboption Custom configurations that you will apply specifically custom administrative code job schedules and DDL triggers. What follows is the pseudo code for what the configuration script will automate for you. All told I would estimate that the configuration script will save about 30 minutes of manual configuration effort. More important than the time saving however is the fact that this script offers a repeatable and accurate configuration for each server. SQL Server Memory If 64-bit do not enable AWE If 32-bit SQL 2008 Standard on Windows 2003 Enterprise and RAM is more than 4G Set max server memory 2G less than Total Server Memory If 32-bit SQL 2008 Standard on Windows 2003 Standard and RAM is less than 4G Set max server memory 2G E-Mail If 2005 automate setup with DBMail SPs Send Test Mail If 2005 Document necessity to create MAPI profile Print steps to configure e-mail 20 1 Eating SQL Server installations for breakfast DDL Triggers Add Server Trigger to notify upon .
