![]() (No, this doesn’t mean the user is active or sleeping at his or her keyboard it means that SQL Server keeps the connection active even though no activity is coming from the login until the user disconnects.)ħ. Task State: Indicates whether the user is active or sleeping. Database: The current database context for the connection.ĥ. Login: The login to which the process is tied.Ĥ. You can change the value to see the SQL Server internal processes by clicking the drop down and selecting the appropriate value.ģ. These processes are filtered out by default. User Process Flag: Indicates whether processes that are internal SQL Server processes are connected. ![]() If you see an hourglass, you can quickly tell that the process is waiting on or is being blocked by another connection.Ģ. An icon next to the number represents what is happening in the connection. Session ID: The unique number assigned to a process connected to SQL Server. ![]() To open the Activity Monitor in Management Studio, right click on the Server in the Object Explorer, then select Activity Monitor.ġ. The monitor can be used to determine whether we have any processes blocking other processes. The Activity Monitor gives us a view of current connections on an instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |