Sessions

The Sessions window shows information about the sessions activity. 

Connections

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.

Accesses /sec

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.

See also:

 





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap