I - Database Park Manager (DPM), a free software to manage a database (DB) park with :
-
PostgreSQL, MySQL, Oracle, SQL Server, SAP (ASE and IQ) under Unix or Windows
II - DPM is a web tool (under IIS) with following features :
1. Monitoring :
-
Collection, historization and visualization of important metrics
-
Collection may work for DB hosted on VM/os-cluster/Container/Cloud (AWS or Azure)
-
Collection may be done remotely from website or by script-execution on db-host
2. Exploitation :
-
Portable exploitation-scripts (ksh or powershell) which may work for any DB installation
-
Scripts may work for DB hosted on VM/os-cluster/Container/Cloud
-
Scripts may be deployed by website or installed manually to db-host (or to dedicated-host
for DB hosted on Cloud: because its db-host is not accessible)
3. Troubleshooting :
-
Real-time DB activity-reporting to identify the root-cause for various issues
4. And more :
-
DB-refresh, SQL-script delivery, capacity-planning, etc
III - DPM is easy to install and use (may manage 3000 instances with 1 WIN-Server of 6GB ram) :
-
DPM is easy to integrate to existing DB-park (no agent to install on db-hosts, no object created in DB)
-
Windows-authentication is used for connecting to DPM (Active-Directory or Workgroup)
-
With our experience, DPM can be crucial in solving over 80% of issues in a production environment
* Notes
1. DPM allows you to achieve following goals :
-
To collect important metrics like slow-query-texts, blocked-sessions, etc
-
To find the root-cause of performance issues (now or in the past)
-
To install and exploit easily (1 or 2 hours may be ok for its installation)
2. On SmartPhone, it's better to choose "Desktop site" to view the pages
All your comments, requests and suggestions are welcome.
Now you can go to the Download or Documentation page (in menu-bar), thank you for visiting !