3

I'm aware this type of question has been asked many times before:

But my question has a twist, I want to monitor a system and correlate CPU - IO stats with SQL Server usage stats, I want to be able to say that at 13:45 the query "select * from bar where baz = 'quux'", ran on SQL Server 1, used up to 80% CPU for 6 seconds with an IO load of 6 and an average disk queue of 15.

I can do this now with a combination of perfmon, SQL Profiler and some custom scripts to correlate the data. I want some tool to do this all for me now.

Do I expect too much? Is there a tool which does things like this?

The usually mentioned candidates are:

But, as far as I can tell, none of those have everything I want. Or does some and I've missed it?

4

You're unhappy with the built in functionality profiler provides where you can combine perfmon data files?

The magic happens in Profiler with the File->Import Performance Data... option. What this means is you can click on your perform graph (where your CPU is spiking) and profiler will jump to the corresponding capture that was happening at that moment.

This was a new feature introduced in SQL Server 2005.

check this out

  • +1. I was unaware of this functionality, thanks a lot. (Will accept if nobody else suggests anything better in a day or so). – Vinko Vrsalovic Jun 1 '09 at 9:09
  • I was using 2005 for months before someone pointed it out to me. It was like striking gold!! – Nick Kavadias Jun 1 '09 at 9:10
  • Yes, this is the way to go. – Sam Jun 1 '09 at 23:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.