|ID||Task||Directions and/or screenshot|
Select a time period when you suspect SQL Server performance issues are occurring, when you are able to run Profiler
and Performance Monitor at the same time. Keep in mind that running both will consume a lot of resources.
|2||Profiler: Configure and save the Profiler trace data to a table or file and be sure to capture both the start and end-time values for SQL Server 2005 Profiler.||Reference the SQL Profiler: Features, functions and setup in SQL Server 2005 tip for instructions on how to set Profiler.|
|3a||Performance Monitor: Configure and save the Performance Monitor Counter Log and save the results to a log in the format of a comma-delimited text file.
Open Performance Monitor by pressing 'CTRL + R' and typing 'perfmon.'
Once Performance Monitor loads, click on the 'Counter Logs' on the left pane and the screen should look like the one on the right.
|3b||General Tab: Right click in the right pane and select 'New Log Settings…'
Give the trace a meaningful name that will be easily recognizable to you.
On the 'General' tab, click on the 'Add Objects' button to launch the 'Add Objects' interface in 3c.
Also, remember where the log file is saved to reference in your upcoming analysis.
|3c||Add Objects: From the General tab, click "Add Objects." Then scroll down the list of performance objects, highlight those needed, click the 'Add' button once you select all the performance objects, and then press the 'Close' button to save the configuration.|
|3d||Log Files Tab: On this tab, select the 'Log file type' as 'Text File (Comma delimited).'|
|3e||Schedule Tab: On this tab, configure the schedule parameters.
Press the OK button to start the data capture.
Associating SQL Profiler and Performance Monitor data
Part 1: Configuring Profiler and Performance Monitor
Part 2: Capturing data
Part 3: Associating and analyzing data
|ABOUT THE AUTHOR:|
| Jeremy Kadlec
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the SearchSQLServer.com Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget
More information from SearchSQLServer.com