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!