Summary
In this chapter, we discussed a generic strategy on how to diagnose and troubleshoot common performance problems in your database application running on SQL Server. Given the large number of possible applications with all their varied workloads and hardware configurations that can be deployed on SQL Server, it is nearly impossible to foresee all performance problems and provide an absolutely comprehensive set of troubleshooting guidelines. Our hope is that what we have described so far can give you a good idea of some key System Monitor counters and DMVs to get you started. As your experience with the application grows, you will develop your own set of data that needs to be monitored. But whatever data that you collect, it is important ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 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.
