Monitoring and Tuning SQL Server
As with monitoring and tuning your hardware, you need to know how SQL Server operates and what to look for when monitoring and tuning your SQL Server solution. You need to choose the appropriate tool that will allow you to gather the information you need to correctly analyze any existing problems and respond accordingly.
Tools for Monitoring and Tuning SQL Server
SQL Server has a rich set of tools and command that can be used to monitor and tune your SQL Server instance. As a DBA, you need to identify the correct tool to use to solve your monitoring or tuning requirements. The more commonly used tools that come with SQL Server include the following:
DBCC Commands. A set of commands used to perform administrative tasks ...
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.
