Transaction information failure

Solved1.01K 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 Enabler] Selected answer as best 1st April 2022

1 Answer

2
6.02K 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 Enabler] Selected answer as best 1st April 2022
Arunkrishna Shreeder [SLC] [DevOps Enabler] 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 🙂