So not only give the status on the db, but also the ability to execute a SQL statement and/or stored-procedure? Not sure if SQL SMO is able to do that.
dirk On 2015-05-05 14:50, Lau Daniels wrote: > Dirk, > >> From my experience with external check, I prefer this type of checks >> to be external. > If the check takes a "long time" to complete it's not interfering with > the other checks of SA. > > It would be nice if the check can work with different custom sql > checks, eg. to see the results of some stored views. > > Lau > > -----Original Message----- > From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On > Behalf Of dirk > Sent: dinsdag 5 mei 2015 13:40 > To: Servers Alive Discussion List > Subject: RE: [SA-list] SQL server checks > > What do you mean with "custom SQL"? > And why external and not internal? > > dirk. > > On 2015-05-05 11:15, Lau Daniels wrote: >> Dirk, >> >> It no problem for me to remove the old checks, we use sql 2008/2014 An >> external com is preferable, with some configurable settings >> (database/username/passwd/custom sql check). >> >> Regards, >> Lau >> >> -----Original Message----- >> From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On >> Behalf Of dirk >> Sent: dinsdag 5 mei 2015 10:35 >> To: Servers Alive Discussion List >> Subject: [SA-list] SQL server checks >> >> For some time we have a SQL server check in Servers Alive. This check >> is based on SQL DMO, and only works with realy old version of SQL. >> For newer versions of SQL we have the add-on, however not for the >> newest version of SQL. >> >> There are some questions surrounding that. >> * what version(s) of SQL are you using (and want to check) >> * do you see it as a problem if the 'support' for those old versions >> of SQL (upto SQL2000) would be removed from Servers Alive >> * do you prefer it to be a build-in check (like the current SQL DMO >> based one) or do you prefer an external COM check for it >> >> >> >> >> -- >> 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 >> salive@woodstone.nu 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. >> >> ************************************************** >> This email and any files transmitted with it are confidential and >> intended solely for the use of the individual or entity to whom they >> are addressed. If you have received this email in error please notify >> the sender. >> Any views or opinions presented in this email are solely those of the >> author and do not necessarily represent those of the company. >> >> This footnote also confirms that this email message has been swept by >> MIMEsweeper for the presence of computer viruses but we cannot accept >> responsibility for any loss or damage arising from the use of this >> email and/or attachment(s). >> >> To unsubscribe send a message with UNSUBSCRIBE in the subject line to >> salive@woodstone.nu 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 > salive@woodstone.nu 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 > salive@woodstone.nu > 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 salive@woodstone.nu 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.
