Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Correlating Performance Monitor and SQL Server Profiler Data

By:   |   Read Comments (4)   |   Related Tips: More > Performance Tuning

ALERT: Did you know 66% of DBAs say their workload is increasing! - Click here to learn more.

Just about all SQL Server performance related tips talk about using data from Performance Monitor and data from SQL Profiler.  The big draw back has always been that they are two totally separate tools, with different interfaces and therefore you need to figure out a way to correlate the data between the two applications on your own.  This was the old way of doing things, but with SQL Server Profiler for SQL 2005 this has changed.

The version of SQL Server Profiler that comes with SQL Server 2005 allows you to load both performance counter data and trace data.  The bonus here is that this works for both SQL Server 2000 and SQL Server 2005 trace data.

The first thing you need to do is collect performance data and trace data. This can be done either manually or by using an automated approach such as was shown in this tip Collecting Performance Statistics for Scheduled Jobs and this tip SQL Server Performance Statistics Using a Server Side Trace.

Once you have the data collected you need to launch SQL Server Profiler for SQL 2005 and load your trace file.

 After you load your trace file you need to import your performance data.

After you load the trace data, you now need to select the performance counters you want to see along with the trace data.  Don't be tempted to select everything, because the performance metric graphs will be hard to read.

As you navigate through the trace data or the performance data the corresponding data will also be shown. The following screen shows you the corresponding SQL statement along with the performance counters during that time frame.

As you can see this is pretty easy and also can give you added insight by looking at both sets of data at the same time. The only thing to keep in mind is that you need to make sure you collect the StartTime and EndTime in the trace file, so this tool can correlate the times when displaying the data.

Next Steps

Last Update:

next webcast button

next tip button

About the author
MSSQLTips author Greg Robidoux Greg Robidoux is the President of Edgewood Solutions and a co-founder of MSSQLTips.com.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Friday, March 23, 2012 - 3:19:36 PM - Greg Robidoux Back To Top

SS - does your trace data that you captured include the startTime column?

Also, you need to save the profiler trace data using the File > Save As > Trace File... option and then open the trace file and see if the option is enabled.

Friday, March 23, 2012 - 1:13:30 PM - ss Back To Top

this option is not enabled in profiler trace. do i need choose any differant settings?? pldhelp


Thursday, May 12, 2011 - 7:53:09 AM - Greg Robidoux Back To Top

I haven't tried it, but I think it should still work the same way.  Let me know how it goes.

Thursday, May 12, 2011 - 6:52:29 AM - doodles Back To Top

Hi there. Is it possible to do this with Windows 2008 Performance & Reliability Monitor?? I sure hope so!



Learn more about SQL Server tools