We have ArcGIS Monitor installed and running but can it monitor if a SQL Server Instance is running or that a SQL Geodatabase is accessing connections?
There is an add-on called EgdbSQL that connects to the actual SQL instance to pull additional stats (connections and uptime being 2 of them). You could set an alert to sound off when the uptime is 0, which would be not running.