New SQL 2005 Features

Hey all! Deepika again.  I just wanted to you all to check out this new feature in SQL 2005.  I think it’s pretty cool!


If you are an MCTS on SQL 2005, chances are you will already know it for sure, but for everyone else, I wanted share a really great improvement. 


The two main tools used to troubleshoot SQL are Perfmon and SQl Profiler.  We can now use 
these two tools at the same time and also, their outputs can be compared by opening the trace file and og file(which has all the counters monitored over a period of time) in SQL Profiler together.


So it no longer takes a long time to decide which stored procedure or query is eating up most of
the resources.

Go ahead, give it a try, and let me know how it works!