monOpenDatabases – additional Counter – ThresholdCrossed
While monOpenDatabases may be handy checking for various DB-related conditions: Active backups (BackupInProgress), Failed Backups (LastBackupFailed), Full DB Log (TransactionLogFull), Existence of LOG SUSPEND SPIDS (SuspendedProcesses) I think there is an additional metric most of us would like to see there: when the last chance threshold (or a custom set threshold) has been crossed for a particular DB. It would be nice grabbing this from MDA to identify this condition rather than parsing DB log – or monErrorLog – and querying lct_admin function and doing maths.
What are the chances we may see this happen in some future?
No idea on the chances.
But it does seem to me that it would be pretty easy to create your own table to log threshold events in, and code all threshold action procedures to insert a row into that table.
That might be an option too. Thanks Bret.