We recently performed our monthly maintenance on all our servers. One of the issues we ran into was that certain services (SQL Server, SQL Server Agent) didn’t start up after a reboot of our MS SQL Servers. I know that I can set them to delayed start or just open services.msc and look for myself, but I was wondering if Spotlight can be configured to alert when these crucial services aren’t running for any reason (crashed, didn’t come up after reboot, not responding, etc.).
Spotlight on SQL Server version 10.5.0.7370