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 !