...
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
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.
...
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 exceeding11exceeding 1,000,000 alarms may need to manually delete the alarms from the Velocity database via SQL Server Management Studio.
...
| Code Block |
|---|
USE Velocity DELETE TOP(1000000) FROM AlarmActive |
Execute Continue to execute the above query until you have deleted all active alarms, and the message box states zero rows affected.
The reason for deleting It is best to delete 1 million alarms at a time is to not exhaust the SQL Server from system memory.
...