Hi - you dono't say what db you are running - I am guessing SQL Server? I can think of a couple of ways from the CF point of view: 1.Create a cfm file that connects to an instance on your db server. E-mail the results of SELECT GETDATE() AS [CurrentDateTime] to you. Set this up as a scheduled task. 2. Use an external monitoring tool (There are thousands, one we use is host-tracker.com) to hit your test cfm file above, and skip the scheduled task and e-mail step. 3. Use a CF tool like FusionReactor or SeeFusion or a system tool like Nagios to monitor all layers of your setup. 4. Figure out your SQL issue! Maybe CF is causing your issue? FR or SF above may help in that regard. Good luck!
On Tue, Apr 14, 2009 at 10:27, Rob Parkhill <robert.parkh...@gmail.com> wrote: > > Good Day, > > Can't come up with a better title, so here is what I want to do. > > I have two servers, one DB and one web. My DB server is having MASSIVE > issues at the moment. CPUs blowing up, and the server shutting down randomly, > at night. I would like to use the webserver (with CF8) to monitor the status > of the DB server, and was wondering what everyone thought was the best > method? I was thinking of checking to see if the domain server (which is > controlled by the DB server) was in existence, although I am not sure if that > is possible with CF. The other thing I could test would be the connection to > the database, but I can't seem to find the references to accessing the admin > tools in CF8, where I thought that would be possible, so any resource > direction would be much appreciated. > > Thanks, > > Rob > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
