Came across an interesting post today about using SQL Profiler to analyze performance issues in SQL Server. More can be found here.
Basically the author provides a custom SQL Profiler template and then a set of stored procs to analyze the output of the captured data for long-running stored procs and most cpu-intensive stored procs etc.
Incidentally, the author (Vyas) has a pretty good web site for everything SQL Server related.
Enjoy!
No comments:
Post a Comment