Minion Enterprise is a management solution – not a monitoring solution. However, we consider downed services well in the domain of management. After all, the DBA should know when their services aren’t performing, well before the end users do! For that reason, ME includes service down alerts.
These alerts feature:
- Night mode, which changes the alert emails to more subdued colors between 10:00pm and 7:00am. (To configure night mode times, see the table dbo.ServerVariables.)
- Tip of the day included with alert emails.
- The ability to define alert exclusions via the dbo.ServiceStatusExceptions table.
- The ability to alert based on services that aren’t running based on their start mode (Automatic, Manual, etc.)
Like all alerts in ME, service down alerts are logged to a table in the History schema – in this case, History.ServiceStatus. This lets you go back and see when alerts fired, and what was in them.
For more information, see “Service Properties Module” and "How To: Alert on non-SQL Server services".
If you want to… | Use… |
Define an exclusion for a specific service on a specific instance | INSERT INTO dbo.ServiceStatusExceptions ( InstanceID, ServiceName, IsActive, Comment ) VALUES ( 11, 'SQL Server Integration Services 12.0', 1, 'It does not matter if SSIS runs on Svr11'); |
Define an exclusion for a service (using wildcards) on a specific instance | INSERT INTO dbo.ServiceStatusExceptions ( InstanceID, ServiceName, IsActive, Comment ) VALUES ( 11, 'SQL Server Integration Services%', 1, ' It does not matter if SSIS runs on Svr11'); |
Define an exclusion for all services on a specific instance | INSERT INTO dbo.ServiceStatusExceptions ( InstanceID, ServiceName, IsActive, Comment ) VALUES ( 11, 'All', 1, 'Low priority server; no alerts'); |
Define an exclusion for a services globally, on all instances (Note: In ME, InstanceID = 0 means “for all instances”.) |
INSERT INTO dbo.ServiceStatusExceptions ( InstanceID, ServiceName, IsActive, Comment ) VALUES ( 0, ' SQL Server Integration Services 12.0', 1, 'Never get alerts for SSIS.'); |
Turn off service down alerts | Disable AlertServiceStatus% jobs. |
https://minionware.desk.com/customer/portal/articles/2517327-service-down-alerts
http://www.MinionWare.net