iv
Summary...................................................................................................................................82
How to Identify Slow Running Queries .........................................................................................85
Creating a Trace to Identify Slow Running Queries...........................................................85
Analyzing the Poorly Performing Queries Identified by Profiler.....................................94
Summary.................................................................................................................................105
How to Identify and Troubleshoot SQL Server Problems .......................................................107
How to Identify Deadlocks..................................................................................................107
How to Identify Blocking Issues.........................................................................................115
How to Identify Excessive Auto Stats Activity.................................................................121
How to Identify Excessive Statement Compilations........................................................125
How to Identify Excessive Database File Growth/Shrinkage .......................................130
How to Identify Excessive Table/Index Scans.................................................................134
How to Identify Memory Problems ...................................................................................139
Summary.................................................................................................................................144
Using Profiler to Audit Database Activity ...................................................................................145
Capturing Audit Events........................................................................................................145
Selecting Data Columns .......................................................................................................148
Selecting Column Filters ......................................................................................................149
Organizing Columns.............................................................................................................150
How to Conduct an Audit Trace.........................................................................................151
Summary.................................................................................................................................153
Using Profiler with the Database Engine Tuning Advisor
........................................................155
Features and Benefits of Using the DTA..........................................................................155
How to Create a Trace for Use by the DTA .....................................................................156
Summary.................................................................................................................................170
Correlating Profiler with Performance Monitor .........................................................................171
How to Collect Profiler Data for Correlation Analysis ...................................................171
How to Collect Performance Monitor Data for Correlation Analysis..........................172
How to Capture Profiler Traces and Perfor
mance Monitor Logs .................................183
How to Correlate SQL Server 2005 Profiler Data with Performance Monitor Data.184
评论1