Share via

SQL Server 2005 - Performance Troubleshooting

  • Article

 

One of the cool things that comes with SQL Server 2005, is that you have the possibility to correlate together the results of a SQL Server Profiler Trace together with a System Monitor (or Performance Monitor - however you want to call it!)  counter data.

 

How can you do this? Well, things are easier than you would think: just collect your data in SQL Profiler and in System Monitor how you usually do. Just make sure to collect the data for the same period of time (how can you correlate them otherwise?)

 

Then, open your trace in SQL Server Profiler and, always from SQL server Profiler, open the counter data you've retrieved with System Monitor (File - Import Performance Data).

 

Here is a preview of the result you'll get: