SQL Server Settings

Blocking SQL

SettingDescriptionRelated Condition
Maximum Duration Threshold Sets the maximum allowed duration for the object.Blocking SQL: DurationThreshold Max

Blocking SQL Source

SettingDescriptionRelated Condition
Maximum Rows To SynchronizeSets the maximum rows of historical event data to collect from this source.N/A
Minimum Block DurationSets the time that must elapse before a Block Condition is triggered.All Blocking SQL Conditions

Databases Source

For more information, see the Fragmentation Manager topic.

Deadlocks Source

SettingDescriptionRelated Condition
Maximum Rows To SynchronizeSets the maximum rows of historical event data to collect from this source.N/A
History Filter

The filter used for history synchronization. Only events that meet the filter criteria are written to the database. For more information, see History Filter.

Note:  The Deadlocks History Filter only impacts what displays on the Event Calendar and doesn't impact deadlock collection. For more information, see Synchronization of Performance Analysis sources section of the History filter topic.

N/A
Collect Deadlock EventsSpecifies whether a deadlock statement collection is enabled.All Deadlock SQL Conditions

Maintenance Plan Source

SettingDescriptionRelated Condition
Auto-watch New ObjectsSpecifies whether new objects are set to watched when they are discovered.All Maintenance Plan Conditions - An object must be watched in order for Conditions to be evaluated for it.
Maximum Rows To Synchronize

The maximum rows of historical data to collect for this source.

N/A

Reporting Services Report

SettingDescriptionRelated Condition
Maximum Runtime ThresholdDefines the maximum allowed runtime for the object.Reporting Services Report: Runtime Threshold Max
Maximum Runtime Threshold PercentDefines the maximum allowed runtime percent for the object.Reporting Services Report: Runtime Threshold Max
Minimum Runtime ThresholdDefines the minimum allowed runtime for the object.Reporting Services Report: Runtime Threshold Min
Minimum Runtime Threshold PercentDefines the minimum allowed runtime percent for the object.Reporting Services Report: Runtime Threshold Min

Reporting Services Report Source

SettingDescriptionRelated Condition
Auto-watch New ObjectsSpecifies whether new objects are set to watched when they are discovered.All Reporting Services Report Conditions -An object must be watched for Conditions to be evaluated for it.
Maximum Rows To SynchronizeThe maximum rows of historical data to collect for this source.N/A
History FilterThe filter used for history synchronization. Only events that meet the filter criteria are written to the database. For more information, see History Filter.N/A

SQL Server Agent Alerts Source

SettingDescriptionRelated Condition
Auto-watch New ObjectsSpecifies whether  new objects are set to watched when they are discovered.  All SQL Server Agent Alert Conditions - An object must be watched in order for Conditions to be evaluated for it.
Maximum Rows To SynchronizeThe maximum rows of historical data to collect for this source.N/A
History FilterThe filter used for history synchronization. Only events that meet the filter criteria are written to the database. For more information, see History Filter.N/A

SQL Server Agent Job

SettingDescriptionRelated Condition
Maximum Runtime ThresholdThe maximum allowed runtime for the object.SQL Server Agent Job: Runtime Threshold Max

Maximum Runtime Threshold Percent

The maximum allowed runtime percentage for the object.SQL Server Agent Job: Runtime Threshold Max
Minimum Runtime ThresholdThe minimum allowed runtime for the object.SQL Server Agent Job: Runtime Threshold Min
Minimum Runtime Threshold PercentThe minimum allowed runtime percent for the object.SQL Server Agent Job: Runtime Threshold Min
Queue Others for up toThe maximum length of time this job will queue other jobs. For more information, see Job Queuing.N/A
Auto-Start ThresholdAny job whose next scheduled run time is beyond the specified threshold starts automatically upon leaving the queue. If a job's next scheduled run time is before the threshold it won't auto-start.N/A
Queue TypeThe behavior when this job is queued. For more information, see Job Queuing.SQL Server Agent Job: Queued
Queue For Up ToThe maximum length of time this job can queued. For more information, see Job Queuing.N/A
Auto-Start TypeControls the auto-start behavior for the job when it leaves the queue. Use default setting causes the queuing job's Auto-Start Threshold setting to be used.N/A

SQL Sever Agent Jobs Source

SettingDescriptionRelated Condition
Auto-watch New ObjectsSpecifies whether new objects are set to watched when they are discovered.All SQL Server Agent Job Conditions - An object must be watched for Conditions to be evaluated for it.
Missed Run Threshold The length of time that must pass before an object run is considered to be missed.SQL Server Agent Job: Run Missed
Maximum Rows To SynchronizeThe maximum rows of historical data to collect for this source.N/A

SQL Server Agent Log Source

SettingDescriptionRelated Condition
Auto-watch New ObjectsSpecifies whether new objects are set to watched when they are discovered.All SQL Server Agent Log Source Conditions - An object must be watched in order for Conditions to be evaluated for it.
Maximum Rows To SynchronizeThe maximum rows of historical data to collect for this source.N/A
History FilterThe filter used for history synchronization. Only events that meet the filter criteria are written to the database. For more information, see History Filter.N/A

SQL Server Instance

SettingDescriptionRelated Condition
Auto-enable SQL Server Agent TokensOn SQL Server 2005 and above, SQL Agent Tokens are disabled as a security measure. They must be enabled to allow SentryOne to watch Alerts.All SQL Server Agent Alert Conditions
Auto-recycle large SQL Server Agent Logs

Specifies whether to automatically recycle large Agent Log files. SentryOne polls the Agent Log for history synchronization. If an Agent Log file becomes too large, this polling causes timeout problems. To prevent this, SentryOne stops polling and issues a Client Alert if the Agent Log file exceeds one MB.

Note:  This problem often manifests when informational level logging is enabled.

N/A
Maximum Queue Length

The maximum number of objects that can be queued at one time.

Note:  This setting always applies to the instance level.

SQL Server Agent Job: Queued
Synchronize TypeThis setting refers to how the SentryOne client responds if it discovers the data in the SentryOne Database isn't up to date. The default is to show a message box warning of the condition and ask if the SentryOne client should synchronize the information itself.N/A
Synchronization ThresholdThe amount of time that passes since the last successful synchronization by the SentryOne monitoring service before the client attempts to synchronize directly with the target.N/A
Max Databases to Synchronize (largest first)The maximum number of databases to synchronize, ordered by total size. This includes system databases.N/A
Maintenance Window

Used to set a schedule for the Maintenance Window. Only Log Actions are triggered for Failsafe conditions inside the Maintenance Window. Maintenance Window settings allow a time frame to be specified while daily maintenance activities take place on that instance.

For more information, see the Schedules and Windows topic.

Failsafe Conditions

Top SQL

SettingDescriptionRelated Condition
Maximum Runtime ThresholdThe maximum allowed runtime for the object. This default value is one hour.Top SQL: Runtime Threshold Max

Top SQL Source

SettingDescriptionRelated Condition
Maximum Rows to SynchronizeThe maximum rows of historical data to collect for this source.N/A
Minimum DurationDetermines the required duration for a Top SQL event to be collected. The default setting is five seconds. For safety reasons, it can't be reduced below 100ms unless one of the CPU Reads or Writes filters is  > zero.All Top SQL Conditions
Minimum CPUThe minimum required CPU for a statement to be logged.All Top SQL Conditions
Minimum ReadsThe minimum required reads for a statement to be logged.All Top SQL Conditions
Minimum WritesThe minimum required writes for a statement to be logged.All Top SQL Conditions
Collect Trace EventsSpecifies whether  to collect Trace Events. If Collect Trace Events is disabled, SentryOne won't start a trace or collect any Top SQL events from a monitored target.N/A
Collect Statement Events

Specifies whether to collect Statement Events. If Collect Statement Events is disabled, statement-level information won't be available in the Plan Explorer Statements Tree when viewing a query plan.

Warning: On systems with very high transaction volumes that make extensive use of scalar functions, enabling Collect Statement Events can cause a negative impact on performance of the monitored target, regardless of the effective Top SQL filter settings or the number of events actually collected. For more information, see the MSDN article Unintended Consequences of Scalar-Valued User Defined Functions.

N/A
Collect Execution Plans

Specifies whether to collect Execution Plans. If Collect Execution Plans is disabled, Top SQL event collection occurs as normal; however, query plan information won't be automatically collected for those events.

Note:  Plan information can still be collected on demand from within a Plan Explorer session.

N/A
Max Plan Size to Collect (MB)Specifies the max plan size to collect in MB. Default value is three.N/A
Running Events Polling IntervalSpecifies how often the service checks for running events.N/A
Collect Query StatsSpecifies whether Query Stats collection is enabled. This setting must be set to True for Procedure Stats and Query Stats to function.N/A
Query Stats Sample IntervalSpecifies how often to sample query stats.N/A
Filter Time SpanSpecifies the base length of time over which the collection filters are applied to Query Stats.N/A
Filter FactorCalculated 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.N/A


Note:  Top SQL Source:

There is an And relationship that exists between the Minimum Duration, Minimum CPU, Minimum Reads, and the Minimum Writes collection settings. This means, that to be collected as Top SQL, the event needs to satisfy each individual collection setting. For example, if you set the Minimum Duration at 10 seconds and the Minimum Reads at 25, an event needs to meet both a Minimum Duration of 10 seconds And a Minimum Read of 25 to be captured in Top SQL.

Minimum Duration can't be set below 100ms unless Minimum CPU, Minimum Reads, or Minimum Writes is greater than zero. This lower limit is enforced because setting this thresholds below 100ms for an extended period of time could dramatically increase the volume of data collected and stored by SentryOne, and have a negative impact on the monitored server. SentryOne's Quick Trace functionality is better suited to analyze extremely short duration events.