Microsoft® SQL Server 2012 Unleashed

Configuration Options and Performance

The following sections explain essential information about many of the most significant SQL Server configuration options and their impact on SQL Server performance. Some of the options don’t have performance implications and therefore may not be addressed in much detail—or at all. As part of each option’s explanation, an indication of whether the option is advanced or basic is given, along with the option’s default value and whether the option is self-configuring. Recommended values are usually indicated for the different types of generalized application processing that the SQL Server is used for (that is, OLTP, OLAP, data warehouse, and mixed). For some configuration options, there may not be recommended ...