Databases Reference
In-Depth Information
➤
SQL process vs. system CPU utilization, including other processes retrieved from the
sys.dm_os_ring_buffers
DMV
➤
Bottleneck analysis graph based on the different waits captured using the SQL 2005/2008
Perf Stats script
➤
A table summarizing the different waits by category, with an aggregated weightage of each
wait category observed during the period of data collection
As shown in Figure 12-9, the i rst two sections of the Bottleneck Analysis report indicate no high
CPU usage on the server from which the diagnostic data was collected. However, a lock-blocking
issue was uncovered during the data collection period. With a single glance at the report, you can
deduce a plethora of information about a system not previously inspected. This is why SQL Nexus is
so widely used by SQL Server professionals: It provides quick insight into the diagnostic data
collected from a SQL Server environment. Of course, you still need to draw your own correlations
from the reports; the tool only acts as a medium for providing the relevant inputs needed for
analysis.
FIGURE 12-9
Search WWH ::
Custom Search