Problem solve Get help with specific problems with your technologies, process and projects.

Part 1: Configuring Profiler and Performance Monitor

Learn how to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor. This step helps you configure each tool.

ID Task Directions and/or screenshot
1 Time period

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

 Home: Introduction
 Part 1: Configuring Profiler and Performance Monitor
 Part 2: Capturing data
 Part 3: Associating and analyzing data

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 Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget

More information from

  • Tip: Top 10 Performance Monitor counters
  • FAQ: SQL Server performance boosters
  • Learning Guide: SQL Server performance tuning A to Z
  • Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.