The Sessions tab contains the following views:
The Sessions tab provides the following options:
SQL Diagnostic Manager provides two paths to access the Sessions tab. The first access path is by clicking the appropriate monitored SQL Server instance, and then clicking the Sessions tab. The second access path is by expanding the Servers tree, and then clicking Sessions for the appropriate instance.
The following alerts are associated with the Sessions tab:
Is the number of sessions blocked by other sessions holding requested locks.
Is the amount of time (in seconds) that a SQL Server session is blocking other sessions.
Is the number of unique client computers connected to the instance.
Is when two processes are waiting for a resource held by the other process.
Displays the longest amount of time between a transaction using a Being Transaction statement and the corresponding Commit Transaction or Rollback Transaction statement, in minutes.
Is the number of queries captured by Query Monitor on the monitored SQL Server instance during the last scheduled refresh.
Provides the CPU time (in seconds) used by a SQL Server sessions.
Calculating the sum of the response time (in milliseconds) to send a batch of SQL statements to the server, process the query, and return the results to the SQL Diagnostic Manager Console.
Is the percentage of user connections allowed that are currently used.
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.| | | | | | | |