When you read a job spec for â€œdatabase administratorâ€, it does not simply say:
- PerformanceÂ Monitoring
It says something like:
- Database Performance Tuning
- Database Security
- Promoting Process Improvement
- Problem Solving
- Presenting Technical Information
- Database Management
- Data Maintenance
- Operating Systems
(List taken in part fromÂ Hiring.Monster.com.)
SoÂ whyÂ are the most popularÂ DBA tools, performance monitoring tools? Those are great, sure, but they donâ€™t even begin to cover the vast majority of DBA responsibilities. What we need isÂ environment monitoring.
I donâ€™t have a website I can link to, to give you a definition of SQL environment monitoring. Thatâ€™sÂ becauseÂ weâ€™veÂ been defining it ourselves, for the past nine years.
AnÂ environmentÂ monitorÂ isÂ a system that allowsÂ administrators to examine the overallÂ andÂ specific health ofÂ database instances.
An environment monitor should touch on performance, yes.Â It should also:
- Manage and monitor security
- Speed audits
- MakeÂ a majority of common DBA tasks effortless
- Collect and present as much systemÂ information as possible, including service packs, disk space,Â errors, and more
- And more
- And also, lots more
Minion Enterprise is far more than glorified maintenance
This is exactly what we builtÂ Minion EnterpriseÂ for: to monitor and manage the environment. To take away the Server-By-Agonizing-Server aspect of administration byÂ introducing the â€œset based enterpriseâ€ approach. ToÂ automate everything that can be automated, and to make data available to the DBA on everything else.