Summary
In this chapter, you learned how to monitor and detect both hardware and SQL Server-related performance problems through the various tools and commands available in both the Windows operating system and SQL Server 2005 environments.
You learned the major subsystems that exist and what specific performance metrics you should watch out for when trying to determine the causes of bottlenecks and to tune the performance of your SQL Server solution.
There are a number of configuration options that exist in SQL Server 2005 that you can modify to tune the performance of your SQL Server solution once you become more familiar with your operational environment.
The tempdb system database plays a more important role in SQL Server 2005 compared to earlier ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
