MS SQL 2008 Server - Activity Monitor

To open Activity Monitor in SQL Server Management Studio

1.

On the SQL Server Management Studio standard toolbar, click Activity Monitor.
2.

In the Connect to Server dialog box, select the server name and authentication mode, and then click Connect.

You can also open Activity Monitor at any time by pressing CTRL+ALT A.
To open Activity Monitor in Object Explorer

*

In Object Explorer, right-click the instance name, and then select Activity Monitor.

To open Activity Monitor when opening SQL Server Management Studio

1.

On the Tools menu, click Options.
2.

In the Options dialog box, expand Environment, and then select General.
3.

In the At startup box, select Open Object Explorer and Activity Monitor.
4.

To activate the changes, close and reopen SQL Server Management Studio.