Settings Pane

Introduction

The Settings pane is where settings are configured for instances, sources, and objects. This tab is also where performance counter thresholds are configured when a counter is selected. Settings can be configured globally, at the instance level, or at the object level, and just like conditions, they work on the principle of inheritance. The scope is determined by items selected in the Navigator pane. For more information, see the Conditions pane topic.

Opening the Settings Pane

The Settings pane and Navigator pane are docked on the Start Page of the SentryOne client by default. Select the Settings tab to display the settings pane.SentryOne Start Page open Settings pane Example of the Settings pane in the SentryOne client 

Note:  If the Settings pane does not open on your default installation, select View > Settings on the toolbar to display it. Select the desired site, group, target, or instance to begin configuring your settings.SentryOne View Settings toolbar optionSettings from the View menu

Amazon RDS for SQL Server

The following settings are configurable for Amazon RDS for SQL Server:

Amazon RDS for SQL Server

SentryOne Amazon RDS for SQL Server Settings Global
Global

SentryOne Amazon RDS for SQL Server Settings Site/Group
Site/Group

SentryOne Amazon RDS for SQL Server Settings Target
Target

Miscellaneous Settings

SettingDefinitionLevel Configurable
Auto-enable SQL Server Agent TokensWhether or not to enable SQL Server Agent Tokens on SQL Server 2005 instances.
  • Global
Auto-recycle large SQL Server Agent LogsWhether or not to automatically recycle large agent log files in SQL Server 2005 or greater.
  • Global
Collect Session TempDB UsageSet to True to turn on data collection for TempDB Usage and populate the TempDB Session Usage table.
  • Global
  • Site/Group
  • Target
Collect TempDB Object StatsSet to True to turn on data collection for TempDB Usage and populate the TempDB Object Stats charts.

See the Troubleshooting article for more guidance on this setting.
  • Global
  • Site/Group
  • Target
Maximum Queue LengthThe maximum number of objects that can be queued at one time. This setting always applies to the connection level.
  • Global
  • Site/Group
  • Target
Inherit from Parent (Global)Specifies whether miscellaneous settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Max User Databases to Synchronize (largest first)The maximum number of databases to synchronize, ordered by total size. This includes system databases.
  • Global
  • Site/Group
  • Target
Max User Database Files to Synchronize ( most active & largest first)The maximum number of user database files to synchronize (most active & largest first).
  • Global
  • Site/Group
  • Target
Inherit from Parent (Global)Specifies whether Synchronization settings are inherited from the parent object.
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for watched instances. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target
Inherit from Parent (Global)Specifies whether Maintenance Window settings are inherited from the parent object.
  • Site/Group
  • Target

Databases Source

SentryOne Amazon RDS for SQL Server Databases Source Settings Global
Global

SentryOne Amazon RDS for SQL Server Databases Source Settings Site/Group
Site/Group

SentryOne Amazon RDS for SQL Server Databases Source Settings Target
Target

General Settings

Setting DefinitionLevel Configurable
Enable Table/ Index Data CollectionSpecifies whether table and index collection is enabled. If disabled no index management functions will be performed.
  • Global
  • Site/Group
  • Target
Max Partitions to Collect Per DatabaseThe maximum partitions to collect.
  • Global
  • Site/Group
  • Target
Min Index Size (MB) to Collect Fragmentation DataThe minimum size of the index in MB to be considered for defrag.
  • Global
  • Site/Group
  • Target
Max Index Size (MB) to Collect Fragmentation DataThe maximum size of the index in MB to be considered for defrag.
  • Global
  • Site/Group
  • Target
Collect Buffer Data when Buffer >8GB

Collecting detailed buffer information is inherently a low overhead process. However, since it takes approximately 1 second per GB of buffer, on larger buffers the associated query can take some time to complete, which may cause it to appear in Top SQL and or generate associated alerts. It is generally safe to enable this setting, since SentryOne ensures that the total time spent per day collecting buffer data will be roughly the same regardless of buffer size, and that collection only occurs when the buffer has changed.

  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the general database source settings are inherited from the parent object.
  • Site/Group
  • Target

Deadlocks Source

SentryOne Amazon RDS for SQL Server Deadlocks Source Settings Global
Global

SentryOne Amazon RDS for SQL Server Deadlocks Source Settings Site/Group
Site/Group

SentryOne Amazon RDS for SQL Server Deadlocks Source Settings Target
Target

Synchronization

SettingDefinitionLevel Configurable
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit from Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

Collection Settings

SettingDefinitionLevel Configurable
Collect Deadlock EventsSpecifies whether the deadlock statement collection is enabled.
  • Global
  • Site/Group
  • Target
Inherit from Parent (Global)Specifies whether the deadlock settings are inherited from the parent object.
  • Site/Group
  • Target

Index Defragmentation

SentryOne Amazon RDS for SQL Server Index Defragmentation Settings Global
Global

SentryOne Amazon RDS for SQL Server Index Defragmentation Settings Site/Group
Site/Group

SentryOne Amazon RDS for SQL Server Index Defragmentation Settings Target
Target

General Defrag Settings

SettingDefinitionLevel Configurable
Primary ScheduleThe schedule on which index analysis and or defrag will be performed, according to the configured reorg and rebuild thresholds.
  • Global
  • Site/Group
  • Target
Operation TypeOptions for Analyze Only and Analyze & Defrag.

See the Fragmentation Manager article for more details.
  • Global
  • Site/Group
  • Target
Reanalyze Indexes After DefragSpecifies whether to run the fragmentation analysis again after defrag.
  • Global
  • Site/Group
  • Target
Fragmentation Scan ModeThe scan mode used when scanning for fragmentation.
  • Global
  • Site/Group
  • Target
Maximum Concurrent OperationsThe maximum concurrent operations to run on a SQL Server Instance.
  • Global
  • Site/Group
  • Target
Delay Between Defrag OperationsWhen Maximum Concurrent Operations is set to 1, you can specify a delay between defrag operations to prevent send/redo queue overload when availability groups or mirroring are in use.
  • Global
  • Site/Group
  • Target
Maximum DurationThe maximum allowed runtime for the defragmentation process.
  • Global
  • Site/Group
  • Target
Partitions (Enterprise Only)Which partitions to include for defragmentation.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the general database settings are inherited from the parent object.
  • Site/Group
  • Target

Index Reorg Settings

SettingDefinitionLevel Configurable
Reorg Threshold %The maximum fragmentation percentage before an index reorg is performed.
  • Global
  • Site/Group
  • Target
Reorg ScheduleDedicated schedule on which reorgs only will be performed, according to the reorg threshold. Rebuilds will not be performed even if the rebuild threshold has been exceeded.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the index reorg settings are inherited from the parent object.
  • Site/Group
  • Target

Index Rebuild Settings

SettingDefinitionLevel Configurable
Rebuild Threshold %The maximum fragmentation percentage before an index rebuild is performed.
  • Global
  • Site/Group
  • Target
Rebuild ScheduleDedicated schedule on which rebuilds only (online or offline) will be performed, according to the rebuild threshold.
  • Global
  • Site/Group
  • Target
Offline Rebuild WindowIf an offline rebuild will be performed as the result of the primary schedule, then only start the offline rebuild during this window.
  • Global
  • Site/Group
  • Target
Sort in tempdbSpecifies whether to use the tempdb for sorting.
  • Global
  • Site/Group
  • Target
Use Online Rebuild (Enterprise Only)Specifies whether to rebuild the index while online (Enterprise Only).
  • Global
  • Site/Group
  • Target
MAXDOP (Enterprise Only)The max degree of parallelism to use during the rebuild.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the index reorg settings are inherited from the parent object.
  • Site/Group
  • Target

Top SQL

SentryOne Amazon RDS for SQL Server Top SQL Settings Global
Global

SentryOne Amazon RDS for SQL Server Top SQL Settings Site/Group
Site/Group

SentryOne Amazon RDS for SQL Server Top SQL Settings Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Duration Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the duration thresholds settings are inherited from the parent object.
  • Site/Group
  • Target

Top SQL Source

SentryOne Amazon RDS for SQL Server Top SQL Source Settings Global
Global

SentryOne Amazon RDS for SQL Server Top SQL Source Settings Site/Group
Site/Group

SentryOne Amazon RDS for SQL Server Top SQL Source Settings Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Minimum DurationThe minimum required duration for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum CPUThe minimum required CPU for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum ReadsThe minimum reads required for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum WritesThe minimum required writes for a statement to be logged.
  • Global
  • Site/Group
  • Target
Collect Trace EventsSpecifies whether traces events are collected.
  • Global
  • Site/Group
  • Target
Collect Statement EventsSpecifies whether statement events are collected.
  • Global
  • Site/Group
  • Target
Running Events Polling IntervalSpecifies how often the service checks for running events.
  • Global
  • Site/Group
  • Target
Collect Execution PlansSpecifies whether execution plans are collected. Running queries will not be captured if this is set to false.
  • Global
  • Site/Group
  • Target
Max Plan Size to Collect (MB)Specifies the max plan size to collect in MB.
  • Global
  • Site/Group
  • Target
Collect Query StatsSpecifies whether query stats collection is enabled.
  • Global
  • Site/Group
  • Target
Query Stats Sample IntervalSpecifies how often to sample query stats.
  • Global
  • Site/Group
  • Target
Filter Time SpanThe Filter Time Span specifies the base length of time over which the collection filters will be applied to Query Stats. See Filter Factor for more details.
  • Global
  • Site/Group
  • Target
Filter FactorThe Filter Factor is calculated by dividing the Query Stats Sample Interval by the Filter Time Span. The collection filters such as Minimum Duration are multiplied by this value when applied to Query Stats collection. For example, using the defaults (Query Stats Sample Interval = 60 Seconds, Filter Time Span = 30 Seconds, Minimum Duration = 5 Seconds) the total cumulative duration of all executions of a query over the 60 second sample interval must be greater than 10 seconds.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the Top SQL settings are inherited from the parent object.
  • Site/Group
  • Target

Analytics Platform System Instance

The following settings are configurable for Analytics Platform System instances:

Analytics Platform System

SentryOne Analytics Platform System Instance Settings Global
Global

SentryOne Analytics Platform System Instance Settings Site/Group
Site/Group


Collection Settings

SettingDefinitionLevel Configurable
Monitor PerformanceControls whether performance monitoring is enabled.Global Site/Group Target
Inherit From Parent (Global)Specifies whether collection settings are inherited from the parent object.Site/Group Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance Window

The maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.

  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether maintenance window settings are inherited from the parent object.
  • Site/Group
  • Target

APS Distributed Queries

SentryOne Analytics Platform System Instance APS Distributed Queries Settings Global
Global

SentryOne Analytics Platform System Instance APS Distributed Queries Settings Site/Group
Site/Group


Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

APS Distributed Queries Source

SentryOne Analytics Platform System Instance APS Distributed Queries Source Settings Global
Global

SentryOne Analytics Platform System Instance APS Distributed Queries Source Settings Site/Group
Site/Group


Queries Settings

SettingDefinitionLevel Configurable
Minimum DurationThe minimum required duration for a statement to be logged.
  • Global
  • Site/Group
  • Target
SQL Request Plan Collection EnabledThis will enable collection of compute node level execution plans.
  • Global
  • Site/Group
  • Target
Collect Distributed Queries ErrorsThis will collect and show errors for distributed queries.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the Top SQL Settings are inherited from the parent object.
  • Site/Group
  • Target

APS Health Alerts Source

SentryOne Analytics Platform System Instance APS Health Alerts Source Settings Global
Global

SentryOne Analytics Platform System Instance APS Health Alerts Source Settings Site/Group
Site/Group


Synchronization

SettingDefinitionLevel Configurable
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

APS Loader Backup Run

SentryOne Analytics Platform System Instance APS Loader Backup Run Settings Global
Global

SentryOne Analytics Platform System Instance APS Loader Backup Run Settings Site/Group
Site/Group


Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Duration Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Azure SQL Data Warehouse Instance

The following settings are configurable for Azure SQL Data Warehouse instances:

Azure SQL Data Warehouse

SentryOne Settings Pane Azure SQL Data Warehouse Global
Global

SentryOne Settings Pane Azure SQL Data Warehouse Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Data Warehouse Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Monitor PerformanceControls whether performance monitoring is enabled.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether collection settings are inherited from the parent object.
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether maintenance window settings are inherited from the parent object.
  • Global
  • Site/Group
  • Target

Azure SQL Data Warehouse Distributed Queries

SentryOne Settings Pane Azure SQL Data Warehouse Distributed Queries Global
Global

SentryOne Settings Pane Azure SQL Data Warehouse Distributed Queries Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Data Warehouse Distributed Queries Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Azure SQL Data Warehouse Distributed Queries Source

SentryOne Settings Pane Azure SQL Data Warehouse Distributed Queries Source Global
Global

SentryOne Settings Pane Azure SQL Data Warehouse Distributed Queries Source Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Data Warehouse Distributed Queries Source Target
Target

Queries Settings

SettingDefinitionLevel Configurable
Minimum DurationThe minimum required duration for a statement to be logged.
  • Global
  • Site/Group
  • Target
SQL Request Plan Collection EnabledThis will enable collection of compute node level execution plans.
  • Global
  • Site/Group
  • Target
Collect Distributed Queries ErrorsThis will collect and show errors for distributed queries.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the Top SQL settings are inherited from the parent object.
  • Site/Group
  • Target

Azure SQL Data Warehouse Loader Backup Run

SentryOne Settings Pane Azure SQL Data Warehouse Loader Backup Run Global
Global

SentryOne Settings Pane Azure SQL Data Warehouse Loader Backup Run Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Data Warehouse Loader Backup Run Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Duration Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Azure SQL Database Instance

The following settings are configurable for Azure SQL Database instances:

Azure SQL Database

SentryOne Settings Pane Azure SQL Database Global
Global

SentryOne Settings Pane Azure SQL Database Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Database Target
Target

Miscellaneous

Note:  To provide the best experience, some features of monitoring an Azure SQL database require a few small tables and procedures to be stored in the target database. These objects are created and maintained in a SentryOne schema. If you choose not to allow the monitoring objects to be created, the features dependent upon them (e.g., Top SQL collection) are disabled for the target database. This is set to False by default, but it can be changed globally or overridden at the target level.

SettingDefinitionLevel Configurable
Allow SentryOne monitoring objects in targetIn order to provide the best experience, some features of monitoring an Azure SQL Database require a few small tables and procedures to be stored in the target database. These objects will be created and maintained in a SentryOne schema. If you choose to not allow the monitoring objects to be created, the features dependent upon them will be disabled for the target database.

Additional Information: See the Watched Target Objects article for a complete list of database objects that are placed on the watched target.

  • Global
  • Site/Group
  • Target
Collect Session TempDB UsageSet to True to turn on data collection for TempDB Usage and populate the TempDB Session Usage table.
  • Global
  • Site/Group
  • Target
Collect TempDB Object StatsSet to True to turn on data collection for TempDB Usage and populate the TempDB Object Stats charts.

See the Troubleshooting article for more guidance on this setting.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether miscellaneous settings are inherited from the parent object.
  • Site/Group
  • Target

Collection Settings

SettingDefinitionLevel Configurable
Monitor PerformanceControls whether performance monitoring is enabled.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether collection settings are inherited from the parent object. 
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether maintenance window settings are inherited from the parent object. 
  • Site/Group
  • Target

Blocking SQL

SentryOne Settings Pane Azure SQL Database Blocking SQL Global
Global

SentryOne Settings Pane Azure SQL Database Blocking SQL Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Database Blocking SQL Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Blocking SQL Source

SentryOne Settings Pane Azure SQL Database Blocking SQL Source Global
Global

SentryOne Settings Pane Azure SQL Database Blocking SQL Source Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Database Blocking SQL Source Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Minimum Block DurationThe time required to trigger a block condition.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the blocking settings are inherited from the parent object.
  • Site/Group
  • Target

Top SQL

SentryOne Settings Pane Azure SQL Database Top SQL Global
Global

SentryOne Settings Pane Azure SQL Database Top SQL Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Database Top SQL Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Duration Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Top SQL Source

SentryOne Settings Pane Azure SQL Database Top SQL Source Global
Global

SentryOne Settings Pane Azure SQL Database Top SQL Source Site/Group
Site/Group

SentryOne Settings Pane Azure SQL Database Top SQL Source Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Minimum DurationThe minimum duration required for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum CPUThe minimum CPU required for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum ReadsThe minimum required reads for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum WritesThe minimum required writes for a statement to be logged.
  • Global
  • Site/Group
  • Target
Collect Trace EventsSpecifies whether trace events are collected.
  • Global
  • Site/Group
  • Target
Collect Statement EventsSpecifies whether statement events are collected.
  • Global
  • Site/Group
  • Target
Running Events Polling IntervalSpecifies how often the service checks for running events.
  • Global
  • Site/Group
  • Target
Collect Execution PlansSpecifies whether execution plans are collected. Running queries will not be captured if set to false.
  • Global
  • Site/Group
  • Target
Max Plan Size to Collect (MB)Specifies the max plan size to collect in MB.
  • Global
  • Site/Group
  • Target
Collect Query StatsSpecifies whether query stats collection is enabled.
  • Global
  • Site/Group
  • Target
Query Stats Sample IntervalSpecifies how often to sample query stats.
  • Global
  • Site/Group
  • Target
Filter Time SpanSpecifies the base length of time over which the collection filters will be applied to Query Stats. See Filter Factor for more details.
  • Global
  • Site/Group
  • Target
Filter FactorThe Filter Factor is calculated by dividing the Query Stats Sample Interval by the Filter Time Span. The collection filters such as Minimum Duration are multiplied by this value when applied to Query Stats collection.

For example, using the defaults (Query Stats Sample Interval = 60 Seconds, Filter Time Span = 30 Seconds, Minimum Duration = 5 Seconds) the total cumulative duration of all executions of a query over the 60 second sample interval must be greater than 10 seconds.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Azure DB)Specifies whether the Top SQL settings are inherited from the parent object.
  • Site/Group
  • Target

Event Chain

The following settings are configurable for Event Chains:

Event Chain

SettingDefinitionLevel Configurable
Maximum Runtime ThresholdThe maximum allowed runtime for the chain.
  • Global
Minimum Runtime ThresholdThe minimum allowed runtime for the chain.
  • Global

Event Chain Node

The following settings are configurable for Event Chain Nodes:

Event Chain Node

SettingDefinitionLevel Configurable
Maximum Runtime ThresholdThe maximum allowed runtime for the chain node.
  • Global
Minimum Runtime ThresholdThe minimum allowed runtime for the chain node.
  • Global

SQL Server

The following settings are configurable for SQL Server:

SQL Server

SentryOne Settings Pane SQL Server Global
Global

SentryOne Settings Pane SQL Server Site/Group
Site/Group

SentryOne Settings Pane SQL Server Target
Target

Miscellaneous

SettingDefinitionLevel Configurable
Auto-enable SQL Server Agent TokensWhether or not to enable SQL Server Agent Tokens on SQL Server 2005 instances.

Important:  On SQL Server 2005 and above, SQL Server Agent tokens are disabled as a security measure. They must be enabled to allow SentryOne to watch alerts on these servers. Selecting True allows SentryOne to automatically enable these tokens when an alert is watched on a 2005 and above server.

Additional Information: For more information about SQL Server Agent Tokens, see SQL Server Books Online.

  • Global
  • Site/Group
  • Target
Auto-recycle large SQL Server Agent LogsWhether or not to automatically recycle large agent log files in SQL Server 2005 or greater.
  • Global
  • Site/Group
  • Target
Collect Session TempDB UsageSet to True to turn on data collection for TempDB Usage and populate the TempDB Session Usage table.
  • Global
  • Site/Group
  • Target
Collect TempDB Object StatsSet to True to turn on data collection for TempDB Usage and populate the TempDB Object Stats charts.

See the Troubleshooting article for more guidance on this setting.
  • Global
  • Site/Group
  • Target

Maximum Queue Length

This setting specifies the maximum number of jobs that can be queued at one time on this server. For more information, see the Job Queuing topic.

This setting is used to provide more detail than the basic cleaner memory data, but it is higher overhead to collect. Use caution when enabling this setting to ensure it doesn't impact performance. The default value for this setting is False.

Note:  The default value for this setting is 5.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether miscellaneous settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Max User Databases to Synchronize (largest first)The maximum number of databases to synchronize, ordered by total size. This includes system databases.
  • Global
  • Site/Group
  • Target
Max User Database Files to Synchronize (most active & largest first)The maximum number of user database files to synchronize (most active & largest first).
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether synchronization settings are inherited from the parent object.
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether maintenance window settings are inherited from the parent object.
  • Site/Group
  • Target

Blocking SQL

SentryOne Settings Pane SQL Server Blocking SQL Global
Global

SentryOne Settings Pane SQL Server Blocking SQL Site/Group
Site/Group

SentryOne Settings Pane SQL Server Blocking SQL Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Blocking SQL Source

SentryOne Settings Pane SQL Server Blocking SQL Source Global
Global

SentryOne Settings Pane SQL Server Blocking SQL Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Blocking SQL Source Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Minimum Block DurationThe time required to trigger a block condition.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the blocking settings are inherited from the parent object.
  • Site/Group
  • Target

Databases Source

SentryOne Settings Pane SQL Server Databases Source Global
Global

SentryOne Settings Pane SQL Server Databases Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Databases Source Target
Target

General Settings

SettingDefinitionLevel Configurable
Enable Table/ Index Data CollectionSpecifies whether table and index collection is enabled. If disabled no index management functions will be performed.
  • Global
  • Site/Group
  • Target
Max Partitions to Collect per DatabaseThe maximum partitions to collect.
  • Global
  • Site/Group
  • Target
Min Index Size (MB) to Collect Fragmentation DataThe minimum size of the index in MB to be considered for defrag.
  • Global
  • Site/Group
  • Target
Max Index Size (MB) to Collect Fragmentation DataThe maximum size of the index in MB to be considered for defrag.
  • Global
  • Site/Group
  • Target
Collect Buffer Data when Buffer > 8GBCollecting detailed buffer information is inherently a low overhead process. However, since it takes approximately 1 second per GB of buffer, on larger buffers the associated query can take some time to complete, which may cause it to appear in Top SQL and or generate associated alerts. It is generally safe to enable this setting, since SentryOne ensures that the total time spent per day collecting buffer data will be roughly the same regardless of buffer size, and that collection only occurs when the buffer has changed.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the general database source settings are inherited from the parent object.
  • Site/Group
  • Target

Deadlocks Source

SentryOne Settings Pane SQL Server Deadlocks Source Global
Global

SentryOne Settings Pane SQL Server Deadlocks Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Deadlocks Source Target
Target

Synchronization

SettingDefinitionLevel Configurable
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

Collection Settings

SettingDefinitionLevel Configurable
Collect Deadlock EventsSpecifies whether the deadlock statement collection is enabled.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the deadlock settings are inherited from the parent object.
  • Site/Group
  • Target

Index Defragmentation

SentryOne Settings Pane SQL Server Index Defragmentation Global
Global

SentryOne Settings Pane SQL Server Index Defragmentation Site/Group
Site/Group

SentryOne Settings Pane SQL Server Index Defragmentation Target
Target

General Defrag Settings

SettingDefinitionLevel Configurable
Primary ScheduleThe schedule on which index analysis and/or defrag will be performed, according to the configured reorg and rebuild thresholds.
  • Global
  • Site/Group
  • Target
Operation TypeOptions for Analyze Only and Analyze & Defrag.

See the Fragmentation Manager article for more details.
  • Global
  • Site/Group
  • Target
Reanalyze Indexes After DefragSpecifies whether to run the fragmentation analysis after defrag.
  • Global
  • Site/Group
  • Target
Fragmentation Scan ModeThe scan mode used when scanning for fragmentation.
  • Global
  • Site/Group
  • Target
Maximum Concurrent OperationsThe maximum concurrent operations to run on a SQL Server Instance.
  • Global
  • Site/Group
  • Target
Delay Between Defrag OperationsWhen Maximum Concurrent Operations is set to 1, you can specify a delay between defrag operations to prevent send/redo queue overload when availability groups or mirroring are in use.
  • Global
  • Site/Group
  • Target
Maximum DurationThe maximum allowed runtime for the defragmentation process.
  • Global
  • Site/Group
  • Target
Partitions (Enterprise Only)Which partitions to include for defragmentation.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the general database settings are inherited from the parent object.
  • Site/Group
  • Target

Index Reorg Settings

SettingDefinitionLevel Configurable
Reorg Threshold %The maximum fragmentation percentage before an index reorg is performed.Global Site/Group Target
Reorg ScheduleDedicated schedule on which reorgs only will be performed, according to the reorg threshold. Rebuilds will not be performed even if the rebuild threshold has been exceeded.Global Site/Group Target
Inherit From Parent (Global)Specifies whether the index reorg setting are inherited from the parent object.Site/Group Target

Index Rebuild Settings

SettingDefinitionLevel Configurable
Rebuild Threshold %The maximum fragmentation percentage before an index rebuild is performed.
  • Global
  • Site/Group
  • Target
Rebuild ScheduleDedicated schedule on which rebuilds only (online or offline) will be performed, according to the rebuild threshold.
  • Global
  • Site/Group
  • Target
Offline Rebuild WindowIf an offline rebuild will be performed as the result of the primary schedule, then only start the offline rebuild during this window.
  • Global
  • Site/Group
  • Target
Sort in tempdbSpecifies whether to use tempdb for sorting.
  • Global
  • Site/Group
  • Target
Use Online Rebuild (Enterprise Only)Specifies whether to rebuild the index while online (Enterprise Only).
  • Global
  • Site/Group
  • Target
MAXDOP (Enterprise Only)The max degree of parallelism to use during the rebuild.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the index reorg settings are inherited from the parent object.
  • Site/Group
  • Target

Maintenance Plans Source

SentryOne Settings Pane SQL Server Maintenance Plans Source Global
Global

SentryOne Settings Pane SQL Server Maintenance Plans Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Maintenance Plans Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This settings is most applicable to the initial loading process, since subsequent synchronizations will only include new records. Use care when increasing this value – If it is set too high database content can result.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

Reporting Services Report

SentryOne Settings Pane SQL Server Reporting Services Report Global
Global

SentryOne Settings Pane SQL Server Reporting Services Report Site/Group
Site/Group

SentryOne Settings Pane SQL Server Reporting Services Report Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Runtime ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Runtime Threshold PercentThe maximum allowed duration percentage for the object. See the warning below.

Note:  The default value is 250. This means that any time a job runs for less than 10 (default Minimum Runtime Threshold  Percent) or longer than 250 percent of its average runtime, a notification is sent. If too many messages are being received, these settings can be adjusted as needed.
  • Global
  • Site/Group
  • Target
Minimum Runtime ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Runtime Threshold PercentThe minimum allowed duration percentage for the object.

Note:  The default value is 10.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the runtime threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Important:  For the Maximum Runtime Threshold Percent setting, in cases where the average runtime for a job is less than 30 seconds, a maximum allowed runtime value of two minutes is used regardless of the Maximum Runtime Threshold Percent setting value.

If you wish to avoid this, you can do either of the following:

  1. Use the Maximum Runtime Threshold setting rather than Maximum Runtime Threshold Percent setting.
  2. Use a Response Ruleset for the SQL Server Agent Job: Runtime Threshold Max condition that delays alerting until the jobs have run for a duration the user defines. SentryOne Response Ruleset Example

    Explicit time-based thresholds can also be specified. Any time an explicit time-based threshold is specified it overrides the percentage-based thresholds for that object. Time-based thresholds are usually less valuable at the global level, particularly the Minimum Runtime Threshold that doesn't have much value globally. Explicit runtime thresholds tend to be more applicable at the actual instance or object level for overriding the global percentage thresholds on a case-by-case basis.

Note:  Runtime threshold messages for Reporting Services Reports completing in less than two minutes aren't processed until they are complete.

Reporting Services Reports Source

SentryOne Settings Pane SQL Server Reporting Services Report Source Global
Global

SentryOne Settings Pane SQL Server Reporting Services Report Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Reporting Services Report Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This settings is most applicable to the initial loading process, since subsequent synchronizations will only include new records. Use care when increasing this value – If it is set too high database content can result.

Note:  The default is 5000.
  • Global
  • Site/Group
  • Target
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

SQL Agent Alerts Source

SentryOne Settings Pane SQL Server SQL Agent Alerts Source Global
Global

SentryOne Settings Pane SQL Server SQL Agent Alerts Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server SQL Agent Alerts Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This settings is most applicable to the initial loading process, since subsequent synchronizations will only include new records. Use care when increasing this value – If it is set too high database content can result.
  • Global
  • Site/Group
  • Target
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

SQL Server Agent Job

SentryOne Settings Pane SQL Server SQL Server Agent Job Global
Global

SentryOne Settings Pane SQL Server SQL Server Agent Job Site/Group
Site/Group

SentryOne Settings Pane SQL Server SQL Server Agent Job Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Duration Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the runtime threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Behavior when Queuing Other Jobs

SettingDefinitionLevel Configurable
Queue Other For Up ToThe maximum length of time this job will queue other jobs.
  • Global
  • Site/Group
  • Target
Auto-Start ThresholdAny job whose next scheduled run time is beyond the specified threshold will be started automatically upon leaving the queue. If a job’s next scheduled run time is before the threshold it will not auto-start.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the queuing behavior is inherited from the parent object.
  • Site/Group
  • Target

Behavior When This Job is Queued

SettingDefinitionLevel Configurable
Queue TypeThe behavior when this job is queued.
  • Global
  • Site/Group
  • Target
Queue For Up ToThe maximum length of time this job can be queued.
  • Global
  • Site/Group
  • Target
Auto-Start TypeControls the auto-start behavior for the job when it leaves the queue. “Use default setting” will cause the queuing job’s “Auto-Start Threshold” setting to be used.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the behavior when queued is inherited from the parent object.
  • Site/Group
  • Target

SQL Server Agent Jobs Source

SentryOne Settings Pane SQL Server SQL Server Agent Jobs Source Global
Global

SentryOne Settings Pane SQL Server SQL Server Agent Jobs Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server SQL Server Agent Jobs Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.
  • Global
  • Site/Group
  • Target
Missed Run ThresholdThe length of time that must pass before an object run is considered to be missed.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object. 
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This settings is most applicable to the initial loading process, since subsequent synchronizations will only include new records. Use care when increasing this value – If it is set too high database content can result.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

SQL Server Agent Log Source

SentryOne Settings Pane SQL Server SQL Server Agent Log Source Global
Global

SentryOne Settings Pane SQL Server SQL Server Agent Log Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server SQL Server Agent Log Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.Global Site/Group Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object.Site/Group Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This settings is most applicable to the initial loading process, since subsequent synchronizations will only include new records. Use care when increasing this value – If it is set too high database content can result.
  • Global
  • Site/Group
  • Target
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

Top SQL

SentryOne Settings Pane SQL Server Top SQL Global
Global

SentryOne Settings Pane SQL Server Top SQL Site/Group
Site/Group

SentryOne Settings Pane SQL Server Top SQL Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Duration Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Duration Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Top SQL Source

SentryOne Settings Pane SQL Server Top SQL Source Global
Global

SentryOne Settings Pane SQL Server Top SQL Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Top SQL Source Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Minimum DurationThe minimum required duration for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum CPUThe minimum required CPU for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum ReadsThe minimum required reads for a statement to be logged.
  • Global
  • Site/Group
  • Target
Minimum WritesThe minimum required writes for a statement to be logged.
  • Global
  • Site/Group
  • Target
Collect Trace EventsSpecifies whether trace events are collected.
  • Global
  • Site/Group
  • Target
Collect Statement EventsSpecifies whether statement events are collected.

Warning:  On systems with very high transaction volumes that also make extensive use of scalar functions, enabling Collect Statement Events may cause a negative impact on the performance of the monitored target, regardless of the effective Top SQL Filter settings or the number of events actually collected. For more information, see Improve SQL Sever Scalar UDF Performance in SQL Server 2019, and Four Ways to improve Scalar function performance in SQL Server.

  • Global
  • Site/Group
  • Target
Running Events Polling IntervalSpecifies how often the service checks for running events.
  • Global
  • Site/Group
  • Target
Collect Execution PlansSpecifies whether execution plans are collected. Running queries will not be captured if this setting is set to false.
  • Global
  • Site/Group
  • Target
Max Plan Size to Collect (MB)Specifies the max plan size to collect in MB.
  • Global
  • Site/Group
  • Target
Collect Query StatsSpecifies whether query stats collection is enabled.
  • Global
  • Site/Group
  • Target
Query Stats Sample IntervalSpecifies how often to sample query stats.
  • Global
  • Site/Group
  • Target
Filter Time SpanSpecifies the base length of time over which the collection filters will be applied to Query Stats. See Filter Factor for more details.
  • Global
  • Site/Group
  • Target
Filter FactorThe Filter Factor is calculated by dividing the Query Stats Sample Interval by the Filter Time Span. The collection filters such as Minimum Duration are multiplied by this value when applied to Query Stats collection. For example, using the defaults (Query Stats Sample Interval = 60 Seconds, Filter Time Span = 30 Seconds, Minimum Duration = 5 Seconds) the total cumulative duration of all executions of a query over the 60 second sample interval must be greater than 10 seconds.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether Top SQL Settings are inherited from the parent object.
  • Site/Group
  • Target

SQL Server Analysis Services

The following settings are configurable for SQL Server Analysis services:

Analysis Services

SentryOne Settings Pane SQL Server Analysis Services Global
Global

SentryOne Settings Pane SQL Server Analysis Services Site/Group
Site/Group

SentryOne Settings Pane SQL Server Analysis Services Target
Target

Miscellaneous

SettingDefinitionLevel Configurable
Collect Memory by Category DataMemory by Category data provides more detail than the basic Cleaner memory data, but is higher overhead to collect. Use caution when enabling to ensure it does not impact performance.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether miscellaneous settings are inherited from the parent object.
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for watched instances. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether maintenance window settings are inherited from the parent object.
  • Site/Group
  • Target

Top Commands

SentryOne Settings Pane SQL Server Analysis Services Top Commands Global
Global

SentryOne Settings Pane SQL Server Analysis Services Top Commands Site/Group
Site/Group

SentryOne Settings Pane SQL Server Analysis Services Top Commands Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Duration ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the duration threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Top Commands Source

SentryOne Settings Pane SQL Server Analysis Services Top Commands Source Global
Global

SentryOne Settings Pane SQL Server Analysis Services Top Commands Source Site/Group
Site/Group

SentryOne Settings Pane SQL Server Analysis Services Top Commands Source Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Minimum DurationThe minimum required duration for a statement to be logged.
  • Global
  • Site/Group
  • Target
Collect MDX/DAX/DMX/XMLA EventsSpecifies whether the command collection is enabled.
  • Global
  • Site/Group
  • Target
Collect DAX Query Plan EventsSpecifies whether DAX Query Plan events are captured. Note that collecting query plans for complex DAX queries can have a negative impact on performance and should only be enabled for troubleshooting purposes.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether the SSAS settings are inherited from the parent object.
  • Site/Group
  • Target

Tintri

The following settings are configurable for Tintri:

Tintri VMstore

SentryOne Settings Pane Tintri VMstore Global
Global

SentryOne Settings Pane Tintri VMstore Site/Group
Site/Group


Collection Settings

SettingDefinitionLevel Configurable
Monitor PerformanceControls whether performance monitoring is enabled.
  • Global
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target

VMware

The following settings are configurable for VMware:

VMware Host

SentryOne Settings Pane VMware Host Global
Global

SentryOne Settings Pane VMware Host Site/Group
Site/Group

SentryOne Settings Pane VMware Host Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Monitor PerformanceControls whether performance monitoring is enabled.Global Site/Group Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.Global Site/Group Target

Windows

The following settings are configurable for Windows:

Windows Computer

SentryOne Settings Pane Windows Computer Global
Global

SentryOne Settings Pane Windows Computer Site/Group
Site/Group

SentryOne Settings Pane Windows Computer Target
Target

Collection Settings

SettingDefinitionLevel Configurable
Monitor PerformanceControls whether performance monitoring is enabled.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether collection settings are inherited from the parent object.
  • Site/Group
  • Target

Maintenance Window

SettingDefinitionLevel Configurable
Maintenance WindowThe maintenance window for targets. Only Log actions will be triggered for Failsafe conditions inside the maintenance window. Send, Execute, and other actions will not be triggered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether maintenance window settings are inherited from the parent object.
  • Site/Group
  • Target

Process Collection

SettingDefinitionLevel Configurable
Collect ProcessesSpecifies whether process collection is enabled.
  • Global
  • Site/Group
  • Target
Uncategorized Process FilterThe filter controls which uncategorized processes are collected. Categorized or well-known processes are always collected. Once a process has passed the filter, it will continue to be collected until it completes.
  • Global
  • Site/Group
  • Target
Inherit From ParentSpecifies whether process collection settings are inherited from the parent object.
  • Site/Group
  • Target

Windows Event Logs Source

SentryOne Settings Pane Windows Event Logs Source Global
Global

SentryOne Settings Pane Windows Event Logs Source Site/Group
Site/Group

SentryOne Settings Pane Windows Event Logs Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This setting is most applicable to the initial load process, since subsequent synchronizations will only include new records. Use care when increasing this value – if it is set too high database contention can result.
  • Global
  • Site/Group
  • Target
History FilterThe filter used for history synchronization. Only events that meet the filter will be written to the database.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

Windows Task

SentryOne Settings Pane Windows Task Global
Global

SentryOne Settings Pane Windows Task Site/Group
Site/Group

SentryOne Settings Pane Windows Task Target
Target

Runtime Thresholds

SettingDefinitionLevel Configurable
Maximum Runtime ThresholdThe maximum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Maximum Runtime Threshold PercentThe maximum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Minimum Runtime ThresholdThe minimum allowed duration for the object.
  • Global
  • Site/Group
  • Target
Minimum Runtime Threshold PercentThe minimum allowed duration percentage for the object.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the runtime threshold settings are inherited from the parent object.
  • Site/Group
  • Target

Windows Task Source

SentryOne Settings Pane Windows Task Source Global
Global

SentryOne Settings Pane Windows Task Source Site/Group
Site/Group

SentryOne Settings Pane Windows Task Source Target
Target

General

SettingDefinitionLevel Configurable
Auto-watch New ObjectsWhether or not new objects will be set to watched when they are discovered.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether general settings are inherited from the parent object.
  • Site/Group
  • Target

Synchronization

SettingDefinitionLevel Configurable
Maximum Rows to SynchronizeThe maximum rows of historical event data to collect from this source. This settings is most applicable to the initial load process, since subsequent synchronizations will only include new records. Use care when increasing this value – if it is set too high database contention can result.
  • Global
  • Site/Group
  • Target
Inherit From Parent (Global)Specifies whether the maximum row count settings are inherited from the parent object.
  • Site/Group
  • Target

Performance Counter Settings

The Performance Counter settings screen is used to set the minimum and maximum values for the counter thresholds of that particular counter. These are used to trigger the Performance Counter: Threshold Min and Max conditions if any conditions are enabled for them. This option is only available when selecting a specific performance counter from the Navigator pane. The following settings are configurable for Performance Counters:

Counter Thresholds

SentryOne Settings Pane Performance Counter Thresholds Global
Global




SettingDefinitionLevel Configurable
MaximumMaximum performance counter threshold.
  • Global

Minimum

Minimum performance counter threshold.
  • Global