SQL Monitor

I've had various issues that seemed to be caused by a dropped SQL connection. I was having a hard time proving this though, so I came up with the SQL Monitor script to tell me if SQL ever goes down or cannot be connected to from the Deployment Server.

It's very simple, it just checks whether it can make an ADODB (ODBC) connection to your SQL server (the same way Deployment Server makes it's connection) and outputs to a file whether it was able to make the connection or not (and at what date/time).

Simply schedule this script to run (on any computer that has a DS Console installed onto it so the ODBC connection is configured, however for accuracy I recommend running it on your DS) with Windows Scheduler at an interval of your choice, and the log file will be written to the same directory the script is executed from.