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.
...
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.
| Code Block |
|---|
USE Velocity |
...
DELETE TOP(1000000) FROM AlarmActive |
Execute the above query until you have deleted all active alarms, and the message box states zero rows affected.
...