How to reduce CPU usage on a database sensor

Products

• Security Information Manager

Issue/Introduction

You want to reduce the CPU usage used by the SSIM Database Collector

 

Resolution

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.

<prop key="pauseForNoEvents">2000</prop>

<prop key="pauseBetweenRequests">15000</prop>


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.