Hi Dojo,
In the backup agent of a failover pair running MSSQL, we noticed the following :
Does this mean the alarm table is large ? How can we delete the data from the table ?
TIA 🙂
Arunkrishna Shreeder [SLC] [DevOps Advocate] Selected answer as best 1st April 2022
Hi Arun,
Some possible clues and hints:
sl_clean_alarm is a transaction DataMiner runs on MSSQL databases in order to clean out the alarm table.
I would guess that either the queries in that transaction are taking a long time (selecting oldest non-active alarm trees / deleting data for these), or that a failure of these cause the transaction not to be marked as complete.
In the logfiles (SLDatabase[XXX].txt), you should be able to find logging like "-- Start cleaning alarm table" and "-- Done cleaning alarm table" (same for the "info" table)
Arunkrishna Shreeder [SLC] [DevOps Advocate] Selected answer as best 1st April 2022
Hi Wouter, thanks for your feedback. Could you please let me know how to drop the data from the alarm table ? Losing alarm data is not at all an issue here. TIA 🙂