Microsoft® SQL Server 2012 Unleashed

Summary

Dealing with the large number of configurable options in SQL Server is a big undertaking. You not only need to know about the internal address space of SQL Server, but also need to understand what types of applications will be running on the server so that the configuration decisions you make are not counterproductive.

Many of the configurable options have a direct effect on the most dynamic part of SQL Server: the memory pool. This is truly where all the action is. Whether you have chosen to let SQL Server help you manage this space dynamically via self-configuring options or you have decided to manage this yourself, you must constantly monitor the current settings and be prepared to modify them at any time. In general, you can start ...