The db sensor is used by all of the db collectors in SSIM and it has some useful tuning parameters which may be applied in order to reduce load on the database server.
You need to edit your config.xml file located in the collector folder (path depends of the collector).
These settings must be added between the <props>
and </props> tags in the config.xml.
These values are in milliseconds and need to be adjusted to suit your environment.
The "pauseForNoEvents" value stipulates the amount of time the collector should wait before querying the db again if no results were returned by the previous query.
The "pauseBetweenRequests" value stipulates the amount of time the collector should wait before querying the db again if some results were returned by the previous query.
By default the db sensor will run queries against the target db every 100 milliseconds, even if there are no events.