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 104853.
|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.|
The following video details how to change the collection frequencies.