Configure the Agent Settings for Monitoring Database

This page provides information about the different agent properties that are used for database monitoring. For configuring the basic agent properties, see Database Agent Configuration Properties.

You can update the following properties using the controller-info.xml file located in the <db_agent_home>/conf directory.

The following table includes the property names that can be used for any specific database or for all the databases along with the purpose of the properties.

Agent Properties for Monitoring Relational Databases

Property Name Database Purpose Default Value
-Ddbagent.disable.sybase.ase.system.monitoring Sybase

This property specifies whether the agent should disable Sybase. You may want to disable Sybase monitoring with Database Visibility if you are already using other tools to monitor Sybase. Refer to Sybase Database Permissions for information on configuring Sybase permissions.

If an agent is run with the -Ddbagent.disable.sybase.ase.system.monitoring flag, Database Visibility will stop executing sp_sysmon for Sybase databases. As a result, the following metrics might not show reliable data:

  • Calls per Minute (KPI)
  • All metrics under Server Statistic in the Metric Browser
  • The Load value on the Sybase dashboard
 false
-Ddbagent.sampling.interval

All relational database

Note: This property can be used for MongoDB and Couchbase.
 This is the interval at which queries are sampled. The interval can be 1s, 2s, 5s, 10s, 20s, or 30s. For example, if you have configured the property value as 2 , Elapsed Time is displayed for 2s, 4s, 6s, and so on (in the multiples of 2). 1
dbagent.postgresql.database.size.fetch.timeout.in.hrs PostgreSQL This specifies the frequency of collecting the database size statistics for each Postgres SQL collector. This property is required for the environment where you monitor a Postgres SQL database that includes large number of objects. If the value of this property < 1, then the collector does not fetch the value for the size metric. 1

Agent Properties for Monitoring Cassandra

Property Name Purpose Default Value
dbagent.cassandra.sampling.interval.seconds The interval at which queries are sampled. According to the sampling interval (between 1 and 60), the sampling threshold is set (between 300 ms and 1000 ms). 10
dbagent.cassandra.max.query.execution.time.seconds Maximum query execution time. Queries executing for more than this duration are not be sampled. 300
dbagent.cassandra.query.sampling.limit The maximum number of queries to sample in a single sampling period. If this value is 0, query sampling is disabled. 100,000
dbagent.cassandra.dse.skip.slow.query.table.for.sampling Whether to use sampling from query traces instead of the node_slow_log table for DSE Cassandra. false
dbagent.cassandra.apache.sampling.threshold.in.milliseconds Defines the sampling threshold for Apache Cassandra. In other words, queries taking more than this threshold to execute, are sampled by the database agent.
Note: This property sets a fixed sampling threshold. To use a dynamic sampling threshold based on the sampling interval set a negative value to this property.
 -1