Chapter 4. Configuring and Tuning Your SQL Servers

Microsoft SQL Server 2012 was designed to adjust to changing workloads dynamically and to self-tune configuration settings. For example, SQL Server can increase or decrease memory usage 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 configuration settings are adjusted automatically.

Although the SQL Server self-tuning feature works well, there are times when you need to configure SQL Server settings manually. ...

Get Microsoft® SQL Server® 2012: Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.