Delete Velocity Alarms

Introduction

Velocity Alarms are crucial for monitoring important events across your Velocity system but sometimes the number alarms can get out of hand, and all alarms must cleared. Having excessive number of alarms can also negatively impact Velocity client application performance.

Delete alarms through Velocity

The total number of alarms are displayed at the bottom banner of the Velocity Client application. Velocity Alarm Viewer can be configured to display and clear up to 9,999 alarms at a time.

Alarm viewer properties can be opened by selecting the second to last icon in the Alarm Viewer row of icons.

Open

This would be used to clear a system with around 100,000 alarms or less, allowing you to acknowledge and clear 9,999 alarms at a time.

Delete Alarms through SQL Server Management Studio

Velocity Systems with exceeding 1,000,000 alarms may need to manually delete the alarms from the Velocity database via SQL Server Management Studio.

Note: Deleting alarms is irreversible.

1. Open SQL Server Management Studio

2. Connect

3. Expand databases folder

4. Right-Click Velocity Database > Select New Query

5. Execute the following query. Once the query is completed executing, the message box will state you how may rows were affected.

6. Continue to execute the above query until you have deleted all active alarms, and the message box states zero rows affected.

It is best to delete 1 million alarms at a time is to not exhaust the SQL Server from system memory.

Open