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!!!