Would be nice to see, we occasionally have problems with bouncing a database which sometimes doesn't come back up fully...ie service is up but unable return a query from the database.
Additionally, not lists originally but you could do a simple TCP 1433/3306/ect port-check to the database servers...not monitoring the "service" per-say but monitoring a behavior of the service. ~Patrick -----Original Message----- From: Servers Alive Discussion List [mailto:[email protected]] On Behalf Of Dirk Bulinckx Sent: Wednesday, December 11, 2013 4:01 AM To: Servers Alive Discussion List Subject: [SA-list] Database check changes Currently in SA there are several ways to check a database * in SA via the SQL checker (using the old DMO libs) * in SA via the Oracle checker (using the Oracle Windows libs) * external COM check for SQL (2005/2008) using the current SMO libs * external COM check for ODBC * external COM mySQL We are thinking about converting this to 1 type of db check that is based on the "native" client (for Oracle - SQL - Sybase - DB2 - Interbase - SQLBase - mySQL - SQLite - Postgress or ODBC). This would require that you changing your existing db checks (the COM ones would still work, the internal not) and that instead of "just" checking if a database is online (like the current SQL and Oracle check do) we would do execute a SQL statement just as we do in the ODBC checker. The idea is to remove the current MS-SQL and Oracle check from SA and replace it by the above check, other option would be to leave the old checks in it and create a new check (internal or as COM check) I would like some reactions/feedback on this idea.... -- Dirk Bulinckx Servers Alive - http://www.woodstone.nu DNS Hosting on StellarDNS - http://www.stellardns.com To unsubscribe send a message with UNSUBSCRIBE in the subject line to [email protected] If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. To unsubscribe send a message with UNSUBSCRIBE in the subject line to [email protected] If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
