Skip to Content
Author's profile photo Andrew Melkonyan

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?

Cheers,

ATM.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Bret Halford
      Bret Halford

      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.

      -bret

      Author's profile photo Andrew Melkonyan
      Andrew Melkonyan
      Blog Post Author

      That might be an option too.  Thanks Bret.