Patches

SWSY-2826: DB Query Monitoring Performance Issue

April 13, 2017
Patch for Monitoring Studio KM for PATROL - Version(s) 9.3.00

This patch is replaced with !

 Download

Patch content

PSL library file

Should you install this patch?

Download this patch if you are using Monitoring Studio v9.3.00 to monitor several DB queries and experience performance issues on the PATROL Agent.

What does it fix?

Configuring Monitoring Studio to monitor multiple DB queries could cause performance issues on the PATROL Agent because of the high amount of memory consumed by multiple Java processes.

How to install the patch?

  1. Unzip SEN_MS_dbquery.zip
  2. On Windows, copy the SEN_MS_dbquery.lib file to the %PATROL_HOME%\lib\psl directory on the managed systems, while logged in as default PATROL Agent user.
  3. On UNIX, copy the SEN_MS_dbquery.lib file to the $PATROL_HOME/lib/psl directory on the managed systems, while logged in as default PATROL Agent user.
  4. Restart the PATROL Agent.
Note: If the maximum limit set (10 by default) does not meet your requirements, adjust this limit by setting the PATROL configuration variable, /SENTRY/STUDIO/maxConcurrentDbQueries (applicable across all monitored hosts). Alternatively, you can also use the PSL code below through PATROL System Output: %PSL pconfig("REPLACE", "/SENTRY/STUDIO/maxConcurrentDbQueries", );