Many tools can help you manage a few instances of Oracle, MS SQL Server, MariaDB, Sybase, Postgres, MongoDB or MySQL. But when you have a couple of hundred instances, or maybe even a few thousand instances spread over multiple sites and possibly in various clouds like Azure or AWS, you run into a new set of issues and requirements that you must address.
In dbWatch, we have provided large service providers, hospital groups, military, retail, and other large and demanding enterprises with database monitoring solutions for over ten years. dbWatch Control Center can meet the most demanding requirements for large-scale operations. It has many features for managing the large number of instances we encounter:
You need the same fast response when you monitor ten or a thousand instances. Also, there is no performance degradation on the network or central repository. (Hint: we use a distributed storage and server architecture to minimize load and performance issues)
dbWatch has dashboards that will always give you an instant overview of all your instances, regardless of the number or platform. You will always have full situational awareness.
A distributed dbWatch server architecture lets you distribute the load over multiple dbWatch servers or put the dbWatch servers behind firewalls or on different sites. This will spread the load and transparently reduce complexity with segmented and firewalled networks from the monitoring station and DBAs.
With extensive estates, you need views and tools that give you global overviews of all your instances. Then you can sort the lists to see where the biggest loads are quick, the most disk or memory usage, most giant lock or waits for issues, or any other parameter. You need - and get - the flexibility to analyze your entire estate in any way you need to get the information you need.
When dealing with hundreds or thousands of instances, you need to organize them flexibly. With dbWatch, you can make arbitrary groups, like Development/Test/Operations, Sales/Production/Finance, location, or platform - the choice is yours. Further, you can tag any instance with your properties and make arbitrary groups based on those. Whichever way you want it, with dbWatch, you can organize your instances the way you want them. Flexible and powerful.
You want to control access if you have a large estate, perhaps in multiple locations and timezones. With dbWatch, you can create role-based access and manage different roles in other parts of your estate. A flexible and powerful access control scheme supporting Active Directory, Kerberos, and certificates/encrypted connections makes this easy to set up and maintain.