Proactive Monitoring of Database Servers

摘要

A computer system monitors database servers to mitigate server availability risks. The plurality of servers may be proactively monitored to determine database status at each server before an alert is generated. An automated proactive process executes at a user's desktop to monitor database features over a plurality of database servers. Information about the server status is presented in a graphical user interface (GUI) format where status information for all of the database servers is presented in one integrated view in an automated manner. For example, the monitoring process reads a list of SQL instances and then connects to each listed SQL server to query the system catalogs of an SQL server engine. The monitoring process interprets the received information from the SQL servers and updates the GUI. The GUI may be color-coded to indicate the status state of individual SQL features for each monitored SQL server.