Documentation
 
 
 
PrevFast BackwardFast ForwardNext

Chapter 20. EnterpriseDB DBA Management Server

Table of Contents
20.1. Introduction
20.2. DBA Management Server Login
20.3. Database Read/Write Activity Report
20.4. Add/Remove Cluster
20.5. Monitoring
20.5.1. User Activity Report
20.5.2. Lock Status Report
20.5.3. Buffer Cache
20.5.4. Configuration
20.6. Security
20.6.1. Column Privileges Report
20.6.2. View DB Logs
20.6.3. Constraints Report
20.6.4. View Audit Logs
20.6.5. Show Settings Report
20.7. SQL
20.7.1. iQuery
20.7.2. Query Profiler
20.8. Scheduler
20.8.1. Schedule DB Jobs
20.8.2. View DB Jobs
20.8.3. View Snapshot Jobs
20.8.4. DB Job Logs
20.9. Messaging
20.10. Reporting
20.10.1. Statistics
20.10.2. MetaData
20.10.3. Procedural Logic

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.

PrevHomeNext
Debugging a ProgramUpDBA Management Server Login
 
 ©2004-2007 EnterpriseDB All Rights Reserved