Sunday, August 14, 2011

Monitor server with MS SQL profiler



Start off by clicking on the start button>all programs>sql server>performance tools>SQL profiler.


  1. File>New trace

  2. Choose server instance

  3. give trace a name

  4. save to file (I recommend storing to a .trc file).

  5. trace files can get rather large so check use a stop time.

  6. Click run


This utility is great for monitoring , finding slow query response, CPU overhead and auditing users. You even have the option of storing the trace to a database(Not recommended).

Good luck!!!

No comments:

Post a Comment