Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 4 down vote accepted

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

share|improve this answer
    
+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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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