The port check part is already something that can be done using the TCP checker. I didn't list that as a db check as this is not doing much more then checking if the port is active.
dirk On Wed, 11 Dec 2013 16:45:31 +0100, Goggins, Patrick wrote: > 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. -- 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.
