We are having LogsHeld problem in our production environment. This happens once a fortnight roughly. The casinos fall off because of slowness. Forcing holding application recovers.
I need to write a monitor to tarck a situatiion when a transaction log is held for long time that causes everything to slow down.
At the moment I will start with SEC_LOGS_ALLOCATED monitored. If so I will check further(APPL_ID_OLDEST_XACT . . . .). If not I will think that everything is normal.
Any body who might have done this, please advise or correct me .