The Sessions window shows information about the sessions activity.
Active Number of connections which are currently executing a query Idle Number of idle connections Waiting Number of connection which are waiting
The grid located at the middle of the window shows each individual session with the following information for each one:
Sid Session identifier User name user name Lock held/s Number of lock held per second Sql scans/s Number of sequential scans per second. If this number is large, it may indicate some performance problems, especially if the system is in OLTP environment. You then need to do some more further investigations to find out the root cause of excessive sequential scans. Disk sort ratio (%) This ratio records the proportion of sorts that were too large to be completed in memory.
By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Update" button must be unchecked to be able to navigate through the collected snapshots.
Select one or more session in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several sessions are selected, the statistics are aggregated.
Locks help /sec
Shows how many selected sessions are using.
Shows how often the selected sessions are hitting the database.
Sequential scans /sec
Shows how frequently selected sessions are using sequential scans to access data; if this number is too high, you may want to question wether the session ecer uses indexes to retrieve data, and examine its query execution plan more closely to see if it is optimal.
Disk sort ratio (%)
This ratio records the proportion of sorts that were too large to be completed in memory. The higher is the percentage, the more efficient are your sort operations.
Copyright © AgileLoad. All rights reserved.