The monitor reports a Critical State and raises an alert if the amount of space used by active rows in all Memory-Optimized Data files drops below the Threshold setting, expressed as a percentage of the size of data files. This monitor is a dependency (rollup) monitor.
This monitor is considered to be obsolete in this Management Pack.
This monitor is considered to be obsolete in this Management Pack.
Note: This monitor is a dependency (rollup) monitor. The health state for this monitor is determined by best state of any member monitor. Please also review the knowledge base article for related unit monitors.
This monitor reports a Critical State and raises an alert if the Garbage Collector Fill Factor (an amount of space used by active rows in Memory-Optimized Data files, expressed as a percentage of the size of data files) drops below the Threshold setting for all related unit monitors.
Garbage Collection Fill Factor for Memory-Optimized Data Filegroup is the metric that shows the average fill factor across all active data/delta files containing inserted/deleted rows. If this metric is lower than 50%, it indicates that automatic merge is falling behind. This is not an immediate cause of concern as long as the number of CFPs (checkpoint file pairs) is below 8000 and you have plenty of storage available Memory-Optimized Data Filegroup.
More information can be found under the sys.dm_db_xtp_checkpoint_files (Transact-SQL) documentation
http://go.microsoft.com/fwlink/?LinkId=799249
‘How Garbage Collection works’ section can be found under the topic 'Creating and Managing Storage for Memory-Optimized Objects'
http://go.microsoft.com/fwlink/?LinkId=799250
Merge of CFP is kicked off based on an internal merge policy. Please refer to this article for details.
Perform a manual merge and force garbage collection as described in these articles:
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | No |
Target | Microsoft.SQLServer.2014.Database |
Parent Monitor | System.Health.PerformanceState |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.2014.Monitor.DBFileGroupFx.GarbageCollectionState |
Relationship | Microsoft.SQLServer.2014.RelationshipType.DBHostsDBFileGroupFx |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2014.DependencyMonitor.Database.GarbageCollectionState" Accessibility="Public" Enabled="true" Target="SQL2014Core!Microsoft.SQLServer.2014.Database" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" RelationshipType="SQL2014Core!Microsoft.SQLServer.2014.RelationshipType.DBHostsDBFileGroupFx" MemberMonitor="Microsoft.SQLServer.2014.Monitor.DBFileGroupFx.GarbageCollectionState">
<Category>PerformanceCollection</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>