Documentation
 
 
 

Chapter 20. EnterpriseDB DBA Management Server

20.1. Introduction

The EnterpriseDB DBA Management Server enables database administrators to capture real-time database performance, view statistics, monitor database performance, and to identify configuration issues for an unlimited number of EnterpriseDB and/or PostgreSQL database servers. The product also delivers compelling, richly formatted reports in both HTML and PDF formats.

The DBA Management Server offers powerful features like the ability to view your database server's logs via View DB Logs, determining the longest running and most frequently used queries in you database via Query Profiler, as well as an interactive query executor, iQuery which has the ability to execute both typical SQL queries and stored procedures.

DBA Management Server provides database administrators with the option of monitoring different database activities and stats through real-time reports. The following are the main types of reports processed by the DBA Management Server:

  • Home

  • Monitoring

  • Security

  • SQL

  • Scheduler

  • Messaging

  • Reporting

We will discuss these categories one by one in further detail in the subsequent sections.

 
 ©2004-2007 EnterpriseDB All Rights Reserved