Bringing It All Together with SQL Nexus - SQL Server 2012 Internals and Troubleshooting - page 332

NOTE A conscious decision was made to remove the Realtime Server Status
report for SQL Server 2008 instances and later. It is meant for use only with
SQL Server 2005 instances.

Three sets of reports are available:
➤

SQL Server 2000 Perf Stats

➤

SQL Server 2005 Perf Stats

➤

SQL Server 2008 Perf Stats

The SQL Server 2008 Perf Stats report works for diagnostic data collected from all SQL Server
2008 instances and later. You will see a set of reports available as shown in
(see Figure 12-8) once this report has rendered successfully.

SQL Server 2008 Perf Stats Reports

Report Description

Blocking and Wait Statistics Blocking and wait statistics

Bottleneck Analysis Bottlneck Analysis

Query Hash This report is for Query hash. It is only available in 2008

Spin Lock Stats This report reports spinlock stats

FIGURE 12-8

NOTE If you captured blocking information using the sp_blocker_pss08 stored
procedure (see Microsoft KB 271509), then you need the SQL Server 2000 Perf
Stats report to view the blocking reports, as these reports are designed to use
the set of data collected by the “old” blocker script. The SQL Server 2005/2008
Perf Stats report was designed for data collection done using the SQL Perf Stats
family of scripts. The Bottleneck Analysis and the Blocking and Wait Statistics
reports only work if the SQL Server 2005/2008/2008 R2 Perf Stats scripts
have been used to capture diagnostic data. The existing SQL Server Perf Stats
script available on the CodePlex website can collect blocking and wait statistics
information from SQL Server 2012 instances as well.

Let's i rst consider the non-Proi ler trace aggregation reports available under SQL Server 2008 Perf
Stats Reports. The Bottleneck Analysis report provides three sets of input: