O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required