O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

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

Troubleshooting Database Performance

By the time you are troubleshooting database performance, you are typically trying to resolve a specific known issue. Consequently, there is less of a methodology because it's more of a matter of using the appropriate tool to troubleshoot the known issue.

In some cases, however, you are more interested in getting metrics on the database globally, such as with the number of connections, transactions, amount of blocking, and other key statistical information.

Troubleshooting Tools

Microsoft has introduced some really great tools to troubleshoot database performance at both the high level and the low level in this release of SQL Server. We highly encourage you to look at all of them in depth to get an understanding ...

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