Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Summary view where you can view charts for each Sessions statistic. The following charts display in the Summary tab:
    • Response Time
    • Sessions
    • Lock Statistics: Average Wait Time, Deadlocks, Requests, Timeouts, Waits, and Wait Time
    • Blocked Sessions
  • Details view that lets you create charts with the specific data items you need.
  • Locks view that allows you to create charts based on each lock present on your SQL Server.
  • Blocking view where you can create charts specific to all the Blocking sessions.

...

The following alerts are associated with the Sessions tab:

Blocked Sessions (Count)

Is the The number of sessions blocked by other sessions holding requested locks.

Blocking Session Wait Time (Seconds)

 Is the The amount of time (in seconds) that a SQL Server session is blocking other sessions.

Client Computers (Count)

 Is the The number of unique client computers connected to the instance.

Deadlock

 Is Refers when two processes are waiting for a resource held by the other process.

...

Query Monitor Events (Count)

Is the The number of queries captured by Query Monitor on the monitored SQL Server instance during the last scheduled refresh.

...

SQL Server Response Time (Milliseconds)

Calculating Calculates 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.

User Connections (Percent)

Is the The percentage of user connections allowed that are currently used.

...