How to Use Activity Monitor in Microsoft SQL Server 2008

The Activity Monitor gives us a  view of current connections on an instance. The monitor can be used to determine whether we have any processes blocking other processes. To open the Activity Monitor in Management Studio, right click on the Server in the Object Explorer, then select Activity Monitor. 1. Session ID: The unique number assigned to …

Read more