MicroStrategy Database Connections Monitor shows all Busy and Cached connections to databases. There are two types of connections shown:

• Connections to the Metadata: Shown as <Repository Connection>, they are opened when the User accesses any Project, even if they don't execute any Reports.
• Connections to the source database: Shown as <Database Instance name>, they are opened any time a non-cached Report or Intelligent Cube is executed or non-cached elements are browsed. These connections can also be as follows:
  • Busy: This status is shown when the connection is processing a job.
  • Cached: This status is shown when the job processing has been completed. A cached database connection can then be re-utilized to process new job requests to the same database since it remains open.