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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
