Using database events

[kc-676583]

Hi IQ Experts, 

I have an IQ stored procedure that collects data from iqmon monitoring views and stores this in an IQ table.

I want to execute this stored procedure every minute. I was planning to use an event (as in the CREATE EVENT statement) to collect this data. Most of the CREATE EVENT examples I see in the manuals are simple self-contained monitoring implementations.

Is there any issue with using database events for my use case?

Regards, KC

[RobertWaywell · Accepted solution]

Yes that is an appropriate use of a scheduled event. The event itself can run any stored procedure. 

The thing to be cautious about is how frequently you are querying the monitoring views and the volume of data that you are collecting. I have seen situations where customers have been querying monitoring views so frequently that monitoring workload is having a significant impact on the system performance.