Monitoring Database Instance Connections

A warehouse database connection is initiated any time a user executes an uncached report or browses uncached elements. The Database Connection Monitor enables you to view the number of busy and cached connections to the data warehouse. You 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 in the Database Connections dialog box, on the Advanced tab), the ODBC connection closes, and it no longer displays in the Database Connection Monitor.

To View the Current Database Connections

1. In Developer, log in to a project source. You must log in as a user with the Monitor Database Connections privilege.
2. Expand Administration, then expand System Monitors, and then select Database Connections. The database connection information displays on the right-hand side.

To Delete a Database Connection

In the Database Connection Monitor, right-click the connection and select Disconnect.