Version 2021

Monitor Database Instance Connections

A warehouse database connection is initiated anytime a user executes an uncached report or browses uncached elements. The Database Connection Monitor allows administrators to view the number of busy and cached connections to the data warehouse. Administrators can also view the name of the database instance, the user who is using the connection, and the database login being used to connect to the database.

If a database connection is cached, the ODBC connection from Intelligence Server to the data warehouse remains open. However, if the data warehouse connection surpasses the connection time-out or lifetime governors (set on the Advanced tab of the Database Connections dialog in MicroStrategy Developer), the ODBC connection closes and it no longer appears in Database Connection Monitor.

  1. Open the Workstation window with the Navigation pane in smart mode.
  2. Log into your environment. You must have the Monitor Database Connections and Monitor Cluster privileges.
  3. In the Navigation pane, click Monitors.
  4. Select an Environment from the upper-left drop-down.
  5. In the left panel, click Database Connections

  6. To disconnect a single session, right-click it and choose Disconnect. To disconnect multiple sessions, first select them using the checkboxes. You must have the Administer Database Connection privilege to disconnect sessions.

  7. Click Export to save the database connection information to a .csv file. This file includes the database connections and the applied filter.
  8. Enable Autofresh to refresh the database connections every thirty seconds. You can also click Refresh to manually refresh when necessary.