We are looking for a tool or web application that can monitor our MS SQL Express server instances which are running on a Windows Server 2012 R2.
It should be possible to get notified when a service is not running anymore.
I can think of two levels of monitoring:
Is the windows service in running mode? We had such situations where the Service was not started again on a Windows Startup
Some basic connectivity check on an SQL level
Found already some Powershell Scripts, which are useful to make connection tests. I am thinking about modifying such a script to get notified via Email when it is not available.
The should be working on a Windows Server 2012. Either free to use or commercial. It should be under active maintenance without adware.