SQL Server 2008 Activity Monitor

Activity Monitor is a simple and quick way to see what’s happening right now in SQL Server,

image

Not too much happening on my demo rig but you get the idea.

It took me a few minutes to open this because my local books on line has an error in it  on how to open it (it suggests expanding form the management tree) so my other tip is to use the books on line that is actually on-line.

Technorati Tags: SQL Server 2008,Activity Monitor