dm_db_xtp_checkpoint_stats


Columns

Column Type Size Nulls Auto Default Children Parents Comments
last_lsn_processed numeric 27 √ null
end_of_log_lsn numeric 27 √ null
bytes_to_end_of_log bigint 8 √ null
log_consumption_rate bigint 8 √ null
active_scan_time_in_ms bigint 8 √ null
total_wait_time_in_ms bigint 8 √ null
waits_for_io_count bigint 8 √ null
io_wait_time_in_ms bigint 8 √ null
waits_for_new_log_count bigint 8 √ null
new_log_wait_time_in_ms bigint 8 √ null
idle_attempts_count bigint 8 √ null
tx_segments_dispatched_count bigint 8 √ null
segment_bytes_dispatched bigint 8 √ null
bytes_serialized bigint 8 √ null
serializer_user_time_in_ms bigint 8 √ null
serializer_kernel_time_in_ms bigint 8 √ null
xtp_log_bytes_consumed bigint 8 √ null
checkpoints_closed bigint 8 √ null
last_closed_checkpoint_ts bigint 8 √ null
hardened_recovery_lsn numeric 27 √ null
hardened_root_file_guid uniqueidentifier 16 √ null
hardened_root_file_watermark bigint 8 √ null
hardened_truncation_lsn numeric 27 √ null
log_bytes_since_last_close bigint 8 √ null
time_since_last_close_in_ms bigint 8 √ null
current_checkpoint_id bigint 8 √ null
current_checkpoint_segment_count bigint 8 √ null
recovery_lsn_candidate numeric 27 √ null
outstanding_checkpoint_count bigint 8 √ null
closing_checkpoint_id bigint 8 √ null
recovery_checkpoint_id bigint 8 √ null
recovery_checkpoint_ts bigint 8 √ null
bootstrap_recovery_lsn numeric 27 √ null
bootstrap_root_file_guid uniqueidentifier 16 √ null
internal_error_code bigint 8 √ null
tail_cache_page_count bigint 8 √ null
tail_cache_max_page_count bigint 8 √ null
tail_cache_min_needed_lsn numeric 27 √ null
merge_outstanding_merges bigint 8 √ null
merge_stats_number_of_merges bigint 8 √ null
merge_stats_log_blocks_merged bigint 8 √ null
merge_stats_bytes_merged bigint 8 √ null
merge_stats_user_time bigint 8 √ null
merge_stats_kernel_time bigint 8 √ null
bytes_of_large_data_serialized bigint 8 √ null

Relationships

Close relationships within degrees of separation