So I have been working through what SQL queries I would like to have executed and based on the results to potentially trigger alerts. However, I know that my list is probably small compared to others. So I come to you to see what other OnBase customers/admins run to monitor their system.
Here is a list of the ones that I have come up with so far.
- Errored out Unity Scheduler Tasks
- Workflow queues that have too many items that shouldn't.
- Distribution Service backlog.
- Unity Scheduler Tasks with "next run time" older than X [time].
- Locks older than X [time].
- Scan queues reaching their batch limit.
What others have you come up with to help monitor your system?
Thanks.
