Tuesday, May 20, 2008

Using Sql profiler to check for performance issue

If you are intending to check for sql server 2000 performance issue, check out this How to identify SQL Server performance issues, by analyzing Profiler output http://vyaskn.tripod.com/analyzing_profiler_output.htm .

It gives you a good template to trace the performance and find the top running stored procedures , high cpu usage , procedure cache usage information.

No comments: