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 Instance Performance

We'll now drill down into the SQL Server 2005 instance and show what tools you have for troubleshooting performance problems. Of course, there will be some overlap with what we have discussed already because the SQL Server 2005 instance is using the same physical server.

Troubleshooting Tools

You have access to quite a large set of tools, on top of the ones we have already introduced and discussed, that you can use to troubleshoot the performance of your SQL Server 2005 instance. Make sure you remember all of them and become familiar with what they return and when it is appropriate to use them, especially the error log files, which always seem to be forgotten.

Summary Report Pane

The Summary Report pane is ...

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