Event monitors

Monitoring table functions and snapshot routines return the values of monitor elements at the specific point in time the routine is run, which is useful when you want to check the current state of your system. However, you might not always want to monitor points in time. There are many times when you need to capture information about the state of your system at exactly the time that a specific event occurs. Event monitors serve this purpose.

Event monitors can be created to capture point-in-time information related to different kinds of events that take place in your system. For example, you can create an event monitor to capture information when a specific threshold that you define is exceeded. The information captured includes such things as the ID of the application that was running when the threshold was exceeded. Or, you might create an event monitor to determine what statement was running when a lock event occurred.