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