Databases Reference
In-Depth Information
11
Consolidating Data Capture
with SQLdiag
WHAT'S IN THIS CHAPTER?
➤
Collecting data for analyzing SQL Server performance
➤
Getting friendly with SQLdiag
➤
Using SQLdiag Confi guration Manager
➤
Employing Best Practices
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
There are no code downloads for this chapter.
THE DATA COLLECTION DILEMMA
One of the biggest issues a SQL Server professional faces when troubleshooting a complex
SQL Server problem is the data collection task. The classic catch-22 situation always presents
itself: installing data collection utilities on the server versus not collecting all the required data
to address the root cause of the problem at hand.
The most common dilemma encountered is using a single tool to capture the required set of
data simultaneously when faced with a critical production issue. Unless and until there are
tools that enable quick coni guration capabilities, we are left gambling with the prospect of
continued service unavailability and missing service-level agreements while trying to coni gure
the data collection tools. Seasoned SQL Server professionals have their own toolset handy,
which they consider to be their equivalent of a superhero's utility belt and which serves them
well at the time of a crisis situation.
Search WWH ::
Custom Search