Chapter 4. Configuring and Tuning Microsoft SQL Server 2008
In this chapter: |
Microsoft designed SQL Server 2008 to balance the workload dynamically and to self-tune configuration settings. For example, SQL Server can increase or decrease memory usage dynamically based on overall system memory requirements. SQL Server also manages memory efficiently, especially when it comes to queries and user connections—and memory is just one of dozens of areas in which the configuration is automatically adjusted.
Although the SQL Server self-tuning feature works well, there are times when you will need to configure SQL Server ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant 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.
