Transaction information failure

Solved911 viewsMSSQL
0
0 Comments

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

1 Answer

2
5.91K 1 Comment

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
Arunkrishna Shreeder [SLC] [DevOps Advocate] commented

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 🙂