This monitor checks the status of the SQL Database XTP Configuration. This monitor is a dependency (rollup) monitor.
Note that this monitor works only with Enterprise, Developer, and Evaluation editions of Microsoft SQL Server. With other editions, the monitor will always be in warning state.
This monitor is a dependency (rollup) monitor. The health state for this monitor is determined by the best state of any member monitor. Please also review the knowledge base article for the related unit monitors.
Note: this monitor works only with Enterprise, Developer, and Evaluation editions of Microsoft SQL Server. With other editions, the monitor will always be in healthy state.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | No |
Target | Microsoft.SQLServer.2016.Database |
Parent Monitor | System.Health.ConfigurationState |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitor |
Relationship | Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx |
Category | ConfigurationHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2016.DependencyMonitor.XTPConfigurationMonitor" Accessibility="Public" Enabled="true" Target="SQL2016Core!Microsoft.SQLServer.2016.Database" ParentMonitorID="SystemHealth!System.Health.ConfigurationState" Remotable="true" Priority="Normal" RelationshipType="SQL2016Core!Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx" MemberMonitor="Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitor">
<Category>ConfigurationHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>