|
Remotely Monitor, Manage and Tune Large Scale Postgres Deployments
Postgres Enterprise Manager was designed with DBAs and large database installations in mind. Its distributed architecture manages all your PostgreSQL instances whether on your hardware or in VMs. Monitoring agents report back from each host to an enterprise management server that collects and reports on data to your specifications. The GUI client console
can be installed where it's convenient. The console not only monitors servers, but manages and tunes all the servers in your organization as well. There is simply no other tool available today capable of such comprehensive management for PostgreSQL databases en-mass.
Perfect Your Performance
Postgres Enterprise Manager is packed with features to monitor and improve the performance of your databases.
A global performance dashboard signals which servers are up, down, or need attention.
Performance home pages present statistics and diagnostics on your databases, I/O, storage, objects, memory, user/session activity, database wait statistics, and the operating system. Use the SQL Profiler to capture running SQL and find the slowest statements. Then, use the EXPLAIN analyzer, Index Advisor and Postgres Expert to implement best practices for your use case, all in an easy graphical interface.
|
|
|
Capacity Planning and Forecasting
Capacity Manager shines a bright light on your hardware utilization by allowing you to specify the automatic collection of desired performance statistics. Then, you can customize which metrics to analyze, including a historical trend analysis over specified blocks of time.
The collected data and subsequent analysis allow you to forecast your resource consumption trends and help plan your data center upgrades or expansion. Capacity Manager also gives you the ability to customize your reports, viewing in graphs and tabular data.
Visual Database Management
Postgres Enterprise Manager provides you with a single management console that allows you to visually manage all aspects of your PostgreSQL servers. You can start and stop PostgreSQL instances, visually change configuration parameters, manage user accounts and security, create and maintain databases, handle all storage management functions tables and associated objects, develop SQL code in a smart editor, perform general backup and restore operations, and register new servers re-using registration for all clients.
Postgres Enterprise Manager is the only tool available with so many features and the ability to apply it graphically and easily over large PostgreSQL installations.
|
