How to change a database agent collection frequency and timeout (4307913)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to change a database agent collection frequency and timeout
Description
The Foglight for database agents always collects and stores data, even when the browser window that displays the data is not active.

This video details how to use the Collection Administration page to specify:
- Which collections are sampled and stored.
- The data collection values when sampling is carried out in offline, online, and real-time frequency modes.
- The collection frequency.
When a user is focusing on a page, the sampling frequency for all the collections associated with this page automatically switches to Real-Time. The collection frequency setting determines the sampling frequencies of the other collections (collections that are not running in Real-Time mode).

The available collection frequencies can be selected from the The selected agent's current collection frequency is (frequency) field located in the middle of the panel.

This video is applicable for Foglight 5.6.11 and higher

Resolution

To change the selected agent's current collection frequency:

Navigate to the Global View Databases Dashboard
Select one or more of the same type of database agent (SQL Server, Oracle, or DB2)
Click Settings | Administration
Click the Collections item
Select the Collection and click the Edit button
The frequency settings dialog displays.
Set the frequencies.
The following settings are provided:
- Low — all collections are running in Offline mode, regardless of whether a Client is connected
- Normal — the collections running mode (Online/Offline/Real-time) adjusts dynamically to the Client's connection status (disconnected/connected/focusing on a page).
- High — all collections are running in Online mode, regardless of whether a Client is connected.
Select the desired settings.
Click Set.
Click the Save Changes button

The Query timeout for on-demand collections setting defines the number of seconds that a query for on-demand collections runs before it times out.

On-demand collections are collections who retrieve data not by predefined time intervals but upon entering a page or clicking a button. The default setting of this parameter is 60 seconds. It can be modified by clicking the number that indicates the parameter’s value in the field Query timeout for on-demand collections.

* IMPORTANT: In the Normal collection frequency, when the browser window that displays Foglight database agent is active, the collection frequency mode in the active page (for example: the Current Sessions panel in the Activity drilldown) switches to the fastest frequency possible, once every 20 seconds.

* NOTE: This section only displays database instance related collections. For details about SQL Server Windows-related collections please see KB 4301510.

Column	Description
Collection Enabled	Defines whether the selected collections are sampled and stored.
Connection Name	The name of the collection. This list is sorted in alphabetical order.
Offline Frequency (Sec)	Allows defining the collection interval, in seconds, in offline mode (for example: 300). Offline frequency is defined as the longest interval possible for sampling the monitored instance.
Online Frequency (Sec)	Allows defining the collection interval, in seconds, in online mode (for example: 60).
Real-time Frequency (Sec)	Allows defining the collection interval, in seconds, in real-time mode (for example: 20). Only one collection can be sampled for a real-time frequency at any given moment.
Query Timeout (Sec)	The amount of time, in seconds, that elapses before the query times out.

To modify the values of a specific collection:

Select the collection’s row in the table.
Click Edit.
The Edit the Collection dialog box appears.
Select whether to enable the collection and storage of the selected collection.
Set the collection interval, in seconds, in offline frequency mode (if available).
Set the collection interval, in seconds, in online frequency mode (if available).
Set the collection interval, in seconds, in real-time frequency mode.
Set the query timeout, in seconds.
Click Set to apply these settings or Cancel to reject them.
Click the Save Changes button

We also have an older panel using the Agent Status Properties