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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment