Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Chat now with support

A Services - Service Not Running alarm is raised when a SQL Server supporting service is installed but not active.

Alarm	Monitored Service
SQL Agent - Status Alarm	SQL Server Agent (SQLServerAgent) service
Services - DTC Service Status Alarm	Distributed Transaction Coordinator (MSDTC) service
Services - Full Text Search Service Alarm	Full-Text Search (Microsoft Search) service
Services - Integration Service Status Alarm	The SQL Server Integration service
Services - Reporting Service Status Alarm	The SQL Server Reporting service
Services - Service Not Running Alarm	Microsoft OLAP/Analysis (MSSQLServerOLAPService) service

When the alarm is raised

Open the SQL Server | Support Services Drilldown | Service Status page. See the status of all known SQL Server support services.
Review messages in the SQL Server | Error Log Drilldown to determine the reason why the service is not running.
Restart the affected service if necessary. This can be done from the Service Status page. Right-click the service in the Services Status grid.

Configuration

This alarm can be configured for your environment. For more information, see Configure | Alarms.

You can configure this alarm to ignore certain services. For more information, see Do not alarm for certain values.
You can configure different severity alarms for different services using keys. For more information, see Configure an alarm.