Running SQL Monitor from the cloud

cmgreenjr_59

Can the monitor application run from a cloud location so it is not dependent on the monitored server's status?

Russell D

Under normal circumstances you would install sql monitor on a standalone machine (this machine can run in the cloud but it would have to be a VM), and then you add the server you want to monitor to it. Installing a monitoring service on the same machine you want to monitor isn't a great idea, because as you've mentioned if that server goes down you're in trouble.

You can run SQL Monitor in HA if that allays any fears: https://documentation.red-gate.com/sm/installation-and-setup/installing-sql-monitor-with-high-availability, but ultimately you would do the above. A standalone install (can be virtually anywhere) monitoring the server you care about.

Russell D

Could you just clarify what you mean please? Do you mean as an application as a service, for example? Or that you want to monitor a single server, but not install it on that server?

cmgreenjr_59

I want to monitor the databases on the server but want the alerts to go to multiple people.  I understand usually a client is running on the server but does the application that does the alerts and shows the status?  In case the server itself goes down, how would I be notified if everything is running on that server?  

cmgreenjr_59

Excellent, thank you.

Russell D

You're welcome, if you do have any other questions just get in touch!