Skip to Main Content
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition
book

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

by William R. Stanek
April 2010
Intermediate to advanced content levelIntermediate to advanced
738 pages
22h 18m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

Chapter 4. Configuring and Tuning SQL Server 2008

Microsoft designed SQL Server 2008 to balance 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 automatically adjusted.

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

William R. Stanek

Publisher Resources

ISBN: 9780735645158Errata