Versions Compared

Old Version 1

changes.mady.by.user Unknown User (6092b4dfd35380006886a5fb)

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

Key

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

...

  • The ability to diagnose performance bottlenecks caused by blocking or locked sessions.
  • The ability to trace specific sessions to see why the session may be blocking or locked.
  • The ability to kill sessions to improve system performance.

Access the Sessions tab

SQLdm 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.

Alerts associated with the Sessions tab

The following alerts are associated with the Sessions tab:

...

Oldest Open Transaction (Minutes)

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.

Query Monitor Events (Count)

...

SQL Server Response Time (Milliseconds)

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 SQLdm Console.

User Connections (Percent)

...