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.
Solution
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.
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.
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.
Open SQL Server Management Studio
Connect
Expand databases folder
Right-Click Velocity Database > Select New Query
Execute the following query. Once the query is completed executing, the message box will state you how may rows were affected.
USE Velocity DELETE TOP(1000000) FROM AlarmActive
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.
