Use Activity Monitor to obtain information about SQL Server processes and how these processes affect the current instance of SQL Server.
Activity Monitor is a tabbed document window that has the following expandable and collapsible panes:
<Please see attached file for image>
When you expand a pane, the Activity Monitor queries the instance for information. When you collapse a pane, the Activity Monitor stops all the activities related to querying for that pane. You can also expand one or more panes at the same time to view different kinds of activities on the instance.
You can customize the display of the columns that are included in Active User Tasks, Resource Waits, Data File I/O, and Recent Expensive Queries panes in the following ways:
You must have VIEW SERVER STATE permissions to view the Activity Monitor in SQL Server 2005 and SQL Server 2008.