Spotlight on SQL Server 10.0.3 - Getting Started Guide

Configure the Alarm: Command - Long Running Command

Note: This alarm applies to Analysis Services 2008 or later.

The Command - Long Running Command alarm becomes active when a command on the Analysis Services server has been running for longer than a specified time frame. Because this time frame is unique to each environment, the Long Running Command alarm, by default, is not configured.

To configure the alarm: Command - Long Running Command

1. Click Configure | Alarms.

   

2. Select an Analysis Services connection to configure. Select Default Settings to apply the configuration to all connections.
3. Select the alarm Command - Long Running Command.
4. Select Override the default settings for the alarm "Command - Long Running Command".
5. Click Add Severity and select a severity.
6. Select the check box of the new severity.
7. Copy and paste the text in the Description cell from the Normal severity to the new severity.

8. In the Start cell, type the duration in seconds, of how long the command should run for before the alarm is raised.

Tip: You can also add a key to this alarm. In the Command - Long Running Command alarm, the key is the SPID. See "Configure Keyed Alarms" (page 1) for more information.

Related Topics

Command - Long Running Command Alarm (page 1)

Spotlight on Analysis Services Alarms (page 1)

Configure Alarms (page 1)

Alarms Dialog (page 1) 

Alarms Ribbon Group (page 1)