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 ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.
