Troubleshooting and Analysis with Traces
The goal of SQL Trace is to help you—presumably, a DBA or database developer—analyze your system in order to either detect or solve problems. As SQL Server is such a large and complex product, using SQL Trace without knowing exactly what you want to do can sometimes feel like trying to find the proverbial needle in a very large haystack. In this section, we’ll try to distill some of the lessons we’ve learned from doing countless traces into a solid framework upon which you can build your own tracing skill. I’ll start with an overview of those event classes that we use most often, after which we’ll drill into some common scenarios for which SQL Trace can helps in your day-to-day work.
Commonly Used SQL ...
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.
