(Click here for an animated set of screenshots, 300 KB)Subquery says the Compact DBA "maximizes use of the existing cellular and WiFi networks" to provide comprehensive monitoring, performance analysis, and alerting of all windows servers as well as SQL Servers on a corporate network. It greatly reduces downtime through proactive alerting and also suggests corrective actions to be taken, according to the company.
 |
How it works
(Click image to enlarge) |
Compact DBA consists of two modules, the company explains. The first is a backend monitoring service that runs on a workstation with access to be able to monitor the production SQL Servers as well as NT and IIS servers. It both monitors the servers and gathers statistics, which it stores on a local database.
The second module runs on a Pocket PC PDA or phone. It accesses the data and statistics captured by the backend service, according to the company. It can also alert the user should any of the more than 65 user settable alert levels be activated. The two modules communicate with each other via an "uncrackable" 168-bit Triple-DES composite cipher key encrypted SSL TCP/IP connection using either WiFi or a GPRS, CDMA, or EVDO cellular phone connection, Subquery says.
Subquery cites recent Gartner data indicating that on average, a database administrator is actually at his/her desk less than 28 percent of the time. If a problem occurs the other 72 percent of the time, "some costly downtime is inevitable." Compact DBA also frees database administrators from routine monitoring and analysis, providing time to concentrate on other tasks or to monitor far more servers, according to the company.
"In order to gain the most out of Compact DBA, a Pocket PC ... phone is required," the company says.
Related stories:
