Styles

Friday, February 15, 2008

Activity Monitor in MSSQL Management Studios 2008

Microsoft seemed to have moved the Activity Monitor from its original location in SQL 2005 to a new one in SQL 2008
It used to be here:



Now it is here:


[Figure 2 - Right-click Database Node > Activity Monitor]


It actually looks a lot like the Windows Task Manager.


[Figure 3 - Windows Task Manager style Activity Monitor.]


This makes it so much easier for you to find out if there are any exclusive locks being made on important queries you are running or even whether or not there are processes eating up the server with query processing.