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 values, but perhaps there may be notes that further explain how they can be used. Remember that there are 70 configuration options; this chapter focuses on the essential ones in alphabetical order (how they are listed in SQL Server).

access check cache bucket count

Type: Advanced Option