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

Part 3: Associating SQL Profiler and Performance Monitor data

Learn how to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor. This section helps you associate and analyze data from each tool.

ID Task Directions and/or screenshot
6a Profiler: Open a new session to start the analysis portion.

Open Data Set: Open the trace data by navigating to File | Open | Trace File or Trace Table menu.

6b Connect to Server: When connecting to a Trace Table, connect to the SQL Server with the captured Profiler data.
6c Source Table: Navigate to the correct database, owner and table with the data.

6d Loaded Data: The data will then load in the Profiler screen.

7a Performance Monitor: In order associate Performance Monitor data with Profiler, click on File | Import Performance Data.

In the 'Open File' interface, navigate to the Performance Monitor file.

7b Performance Monitor Counters: Once the file is read, all of the corresponding counters are read and loaded.

Select the needed counters and press the OK button to load this Performance Monitor data.

7c Both the Profiler and Performance Monitor data will then be in the same interface.

8a Performance Monitor Configuration: To begin analysis, deselect the counters to fine-tune the data displayed in the Performance Monitor window. Basically, you are reducing the number of counters so only those needed for analysis are displayed.

Click in the graph and highlight a portion of the data to zoom in on a smaller period of time.

To zoom back out to the entire time period, right click on the graph and select 'Zoom Out' or 'Show All Data.'

8b Profiler Configuration: Right click on the Profiler window and select 'Properties' on the 'Events Selection' and deselect the counters to fine-tune the selected data.

9 Data Association: With a manageable set of data, it is possible to scroll through the Profiler data. A thick vertical red bar associates it with Performance Monitor to correlate the two metrics.

10 Research and tuning

Continue to review the data based on a best-practices perspective from both the Profiler and Performance Monitor to find performance issues.



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

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

  • 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.

    -ADS BY GOOGLE

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close