How to view current server activity (Enterprise Manager)

How to view current server activity (Enterprise Manager)

To view current server activity

1. Expand a server group, and then expand a server.
   
   
2. Expand Management, and then expand Current Activity.
   
   
3. Click Process Info.

   The current server activity is displayed in the details pane.

See Also

Monitoring with SQL Server Enterprise Manager

Monitoring with Transact-SQL Statements