Database Sessions Window Features

From the Database Sessions window, you can:

  • Choose to view information for the top 10, 50, 100 or 200 sessions consuming database resources.
  • Double click a Session ID to view the queries run in that particular session.

  • Click the down arrow next to the database name at the top of the page to choose to view the database sessions of a different database by either selecting the database from the list or by searching for the database by entering text in the search bar and then clicking the refresh icon to show only databases that meet that search criteria.

  • Click Actions to export the data on this window in a .csv formatted file that is automatically downloaded to your specified downloads directory.
Note: (Database Agent 25.9 or higher) The Session ID column displays the MongoDB lsid if a MongoDB query is associated with any database session. If the query is not associated with any session, then NA is displayed on the Session ID column. MongoDB supports lsid from version 3.6 onwards. For MongoDB version lower than 3.6,

opid

is displayed on the Session ID column instead of lsid.
From the Database Sessions window, you can view:
  • Session ID: the Session ID of each database instance usage.
  • Weight (%): the percentage of time that instance was using the database in comparison with the database usage of other sessions.