New System Object Column Names In SQL Server 2022

Brand New


What does it all mean? We’ll have to find out!

+--------------------------------------------------------+-------------------------------------+
|                      object_name                       |             column_name             |
+--------------------------------------------------------+-------------------------------------+
| backup_metadata_store                                  | backup_finish_date                  |
| backup_metadata_store                                  | backup_metadata_uuid                |
| backup_metadata_store                                  | backup_path                         |
| backup_metadata_store                                  | backup_size                         |
| backup_metadata_store                                  | backup_start_date                   |
| backup_metadata_store                                  | backup_storage_redundancy           |
| backup_metadata_store                                  | backup_type                         |
| backup_metadata_store                                  | checkpoint_lsn                      |
| backup_metadata_store                                  | compressed_backup_size              |
| backup_metadata_store                                  | compression_algorithm               |
| backup_metadata_store                                  | database_backup_lsn                 |
| backup_metadata_store                                  | database_guid                       |
| backup_metadata_store                                  | database_version                    |
| backup_metadata_store                                  | differential_base_guid              |
| backup_metadata_store                                  | differential_base_lsn               |
| backup_metadata_store                                  | first_lsn                           |
| backup_metadata_store                                  | is_damaged                          |
| backup_metadata_store                                  | last_lsn                            |
| backup_metadata_store                                  | last_recovery_fork_guid             |
| backup_metadata_store                                  | last_valid_restore_time             |
| backup_metadata_store                                  | physical_database_name              |
| backup_metadata_store                                  | server_name                         |
| backup_metadata_store                                  | time_zone                           |
| database_ledger_blocks                                 | block_id                            |
| database_ledger_blocks                                 | block_size                          |
| database_ledger_blocks                                 | previous_block_hash                 |
| database_ledger_blocks                                 | transactions_root_hash              |
| database_ledger_digest_locations                       | is_current                          |
| database_ledger_digest_locations                       | last_digest_block_id                |
| database_ledger_digest_locations                       | path                                |
| database_ledger_transactions                           | block_id                            |
| database_ledger_transactions                           | commit_time                         |
| database_ledger_transactions                           | principal_name                      |
| database_ledger_transactions                           | table_hashes                        |
| database_ledger_transactions                           | transaction_id                      |
| database_ledger_transactions                           | transaction_ordinal                 |
| database_query_store_internal_state                    | messaging_memory_used_mb            |
| database_query_store_internal_state                    | pending_message_count               |
| db_ledger_blocks                                       | block_id                            |
| db_ledger_blocks                                       | block_size                          |
| db_ledger_blocks                                       | previous_block_hash                 |
| db_ledger_blocks                                       | transactions_root_hash              |
| db_ledger_blocks                                       | version                             |
| db_ledger_digest_locations                             | is_current                          |
| db_ledger_digest_locations                             | last_digest_block_id                |
| db_ledger_digest_locations                             | path                                |
| db_ledger_digest_locations                             | storage_type                        |
| db_ledger_transactions                                 | block_id                            |
| db_ledger_transactions                                 | commit_LSN                          |
| db_ledger_transactions                                 | commit_ts                           |
| db_ledger_transactions                                 | principal_name                      |
| db_ledger_transactions                                 | table_hashes                        |
| db_ledger_transactions                                 | transaction_description             |
| db_ledger_transactions                                 | transaction_id                      |
| db_ledger_transactions                                 | transaction_ordinal                 |
| db_ledger_transactions                                 | type                                |
| db_ledger_transactions                                 | version                             |
| dm_change_feed_errors                                  | batch_end_lsn                       |
| dm_change_feed_errors                                  | batch_start_lsn                     |
| dm_change_feed_errors                                  | capture_phase_number                |
| dm_change_feed_errors                                  | command_id                          |
| dm_change_feed_errors                                  | entry_time                          |
| dm_change_feed_errors                                  | error_message                       |
| dm_change_feed_errors                                  | error_number                        |
| dm_change_feed_errors                                  | error_severity                      |
| dm_change_feed_errors                                  | error_state                         |
| dm_change_feed_errors                                  | sequence_value                      |
| dm_change_feed_errors                                  | session_id                          |
| dm_change_feed_errors                                  | source_task                         |
| dm_change_feed_errors                                  | table_group_id                      |
| dm_change_feed_errors                                  | table_id                            |
| dm_change_feed_errors                                  | tran_begin_lsn                      |
| dm_change_feed_errors                                  | tran_commit_lsn                     |
| dm_change_feed_log_scan_sessions                       | batch_end_lsn                       |
| dm_change_feed_log_scan_sessions                       | batch_processing_phase              |
| dm_change_feed_log_scan_sessions                       | batch_start_lsn                     |
| dm_change_feed_log_scan_sessions                       | command_count                       |
| dm_change_feed_log_scan_sessions                       | currently_processed_commit_lsn      |
| dm_change_feed_log_scan_sessions                       | currently_processed_commit_time     |
| dm_change_feed_log_scan_sessions                       | currently_processed_lsn             |
| dm_change_feed_log_scan_sessions                       | duration                            |
| dm_change_feed_log_scan_sessions                       | empty_scan_count                    |
| dm_change_feed_log_scan_sessions                       | end_time                            |
| dm_change_feed_log_scan_sessions                       | error_count                         |
| dm_change_feed_log_scan_sessions                       | is_session_failed                   |
| dm_change_feed_log_scan_sessions                       | latency                             |
| dm_change_feed_log_scan_sessions                       | log_record_count                    |
| dm_change_feed_log_scan_sessions                       | schema_change_count                 |
| dm_change_feed_log_scan_sessions                       | session_id                          |
| dm_change_feed_log_scan_sessions                       | start_time                          |
| dm_change_feed_log_scan_sessions                       | tran_count                          |
| dm_column_encryption_enclave_properties                | name                                |
| dm_column_encryption_enclave_properties                | value                               |
| dm_database_backups                                    | backup_file_id                      |
| dm_database_backups                                    | backup_finish_date                  |
| dm_database_backups                                    | backup_start_date                   |
| dm_database_backups                                    | backup_type                         |
| dm_database_backups                                    | database_guid                       |
| dm_database_backups                                    | in_retention                        |
| dm_database_backups                                    | physical_database_name              |
| dm_database_backups                                    | physical_server_name                |
| dm_database_external_policy_actions                    | action_namespace                    |
| dm_database_external_policy_actions                    | action_provider_string              |
| dm_database_external_policy_actions                    | action_type                         |
| dm_database_external_policy_actions                    | sql_action_id                       |
| dm_database_external_policy_principal_assigned_actions | action_namespace                    |
| dm_database_external_policy_principal_assigned_actions | action_type                         |
| dm_database_external_policy_principal_assigned_actions | principal_aad_object_id             |
| dm_database_external_policy_principal_assigned_actions | principal_sid                       |
| dm_database_external_policy_principal_assigned_actions | role_assignment_scope               |
| dm_database_external_policy_principal_assigned_actions | role_assignment_type                |
| dm_database_external_policy_principal_assigned_actions | role_assignment_type_desc           |
| dm_database_external_policy_principal_assigned_actions | role_guid                           |
| dm_database_external_policy_principal_assigned_actions | role_name                           |
| dm_database_external_policy_principals                 | aad_object_id                       |
| dm_database_external_policy_principals                 | authentication_type                 |
| dm_database_external_policy_principals                 | authentication_type_desc            |
| dm_database_external_policy_principals                 | sid                                 |
| dm_database_external_policy_principals                 | type                                |
| dm_database_external_policy_principals                 | type_desc                           |
| dm_database_external_policy_role_actions               | role_guid                           |
| dm_database_external_policy_role_actions               | sql_action_id                       |
| dm_database_external_policy_role_members               | assignment_scope                    |
| dm_database_external_policy_role_members               | assignment_type                     |
| dm_database_external_policy_role_members               | assignment_type_desc                |
| dm_database_external_policy_role_members               | principal_aad_object_id             |
| dm_database_external_policy_role_members               | role_guid                           |
| dm_database_external_policy_roles                      | modify_date                         |
| dm_database_external_policy_roles                      | role_guid                           |
| dm_database_external_policy_roles                      | role_name                           |
| dm_dist_requests                                       | dist_client_id                      |
| dm_dist_requests                                       | dist_statement_hash                 |
| dm_dist_requests                                       | dist_statement_id                   |
| dm_dist_requests                                       | session_id                          |
| dm_dw_databases                                        | database_type                       |
| dm_dw_databases                                        | logical_database_id                 |
| dm_dw_databases                                        | logical_db_name                     |
| dm_dw_databases                                        | sync_point                          |
| dm_dw_locks                                            | acquire_time                        |
| dm_dw_locks                                            | is_user_transaction                 |
| dm_dw_locks                                            | pool_id                             |
| dm_dw_locks                                            | request_id                          |
| dm_dw_locks                                            | request_mode                        |
| dm_dw_locks                                            | request_status                      |
| dm_dw_locks                                            | request_time                        |
| dm_dw_locks                                            | resource_database_id                |
| dm_dw_locks                                            | resource_entity_id                  |
| dm_dw_locks                                            | resource_type                       |
| dm_dw_locks                                            | session_id                          |
| dm_dw_locks                                            | transaction_id                      |
| dm_dw_pit_databases                                    | database_type                       |
| dm_dw_pit_databases                                    | logical_database_id                 |
| dm_dw_pit_databases                                    | pit_db_name                         |
| dm_dw_pit_databases                                    | pit_key                             |
| dm_dw_pit_databases                                    | sql_db_id                           |
| dm_dw_quality_clustering                               | index_id                            |
| dm_dw_quality_clustering                               | max_overlap                         |
| dm_dw_quality_clustering                               | object_id                           |
| dm_dw_quality_clustering                               | partition_id                        |
| dm_dw_quality_clustering                               | quality                             |
| dm_dw_quality_clustering                               | total_cell_count                    |
| dm_dw_quality_clustering                               | total_overlap                       |
| dm_dw_quality_clustering                               | total_row_groups_analyzed           |
| dm_dw_quality_clustering                               | unit_of_work                        |
| dm_dw_quality_delta                                    | index_id                            |
| dm_dw_quality_delta                                    | object_id                           |
| dm_dw_quality_delta                                    | partition_id                        |
| dm_dw_quality_delta                                    | quality                             |
| dm_dw_quality_delta                                    | total_rows_analyzed                 |
| dm_dw_quality_delta                                    | unit_of_work                        |
| dm_dw_quality_index                                    | clustering_quality                  |
| dm_dw_quality_index                                    | delta_quality                       |
| dm_dw_quality_index                                    | index_id                            |
| dm_dw_quality_index                                    | object_id                           |
| dm_dw_quality_index                                    | overall_quality                     |
| dm_dw_quality_index                                    | partition_id                        |
| dm_dw_quality_index                                    | row_group_quality                   |
| dm_dw_quality_index                                    | unit_of_work                        |
| dm_dw_quality_row_group                                | average_rows                        |
| dm_dw_quality_row_group                                | index_id                            |
| dm_dw_quality_row_group                                | object_id                           |
| dm_dw_quality_row_group                                | partition_id                        |
| dm_dw_quality_row_group                                | quality                             |
| dm_dw_quality_row_group                                | total_poor_row_groups_analyzed      |
| dm_dw_quality_row_group                                | total_row_groups_analyzed           |
| dm_dw_quality_row_group                                | unit_of_work                        |
| dm_dw_resource_manager_abort_cache                     | asn                                 |
| dm_dw_resource_manager_abort_cache                     | bsn                                 |
| dm_dw_resource_manager_abort_cache                     | nested_id                           |
| dm_dw_resource_manager_active_tran                     | current_read_version                |
| dm_dw_resource_manager_active_tran                     | ddl_step                            |
| dm_dw_resource_manager_active_tran                     | is_pit                              |
| dm_dw_resource_manager_active_tran                     | is_txn_owner                        |
| dm_dw_resource_manager_active_tran                     | nested_id                           |
| dm_dw_resource_manager_active_tran                     | read_version                        |
| dm_dw_resource_manager_active_tran                     | txn_tag                             |
| dm_dw_resource_manager_active_tran                     | txn_type                            |
| dm_dw_resource_manager_active_tran                     | write_version                       |
| dm_dw_tran_manager_abort_cache                         | asn                                 |
| dm_dw_tran_manager_abort_cache                         | bsn                                 |
| dm_dw_tran_manager_abort_cache                         | nested_id                           |
| dm_dw_tran_manager_active_cache                        | bsn                                 |
| dm_dw_tran_manager_active_cache                        | resource_manager_id                 |
| dm_dw_tran_manager_active_cache                        | tag                                 |
| dm_dw_tran_manager_commit_cache                        | bsn                                 |
| dm_dw_tran_manager_commit_cache                        | csn                                 |
| dm_dw_tran_manager_commit_cache                        | min_active_bsn                      |
| dm_dw_tran_manager_commit_cache                        | state                               |
| dm_dw_tran_manager_commit_cache                        | tag                                 |
| dm_exec_requests_history                               | command                             |
| dm_exec_requests_history                               | data_processed_mb                   |
| dm_exec_requests_history                               | distributed_statement_id            |
| dm_exec_requests_history                               | end_time                            |
| dm_exec_requests_history                               | error                               |
| dm_exec_requests_history                               | error_code                          |
| dm_exec_requests_history                               | login_name                          |
| dm_exec_requests_history                               | query_hash                          |
| dm_exec_requests_history                               | query_text                          |
| dm_exec_requests_history                               | rejected_rows_path                  |
| dm_exec_requests_history                               | start_time                          |
| dm_exec_requests_history                               | status                              |
| dm_exec_requests_history                               | total_elapsed_time_ms               |
| dm_exec_requests_history                               | transaction_id                      |
| dm_external_data_processed                             | data_processed_mb                   |
| dm_external_data_processed                             | type                                |
| dm_external_policy_cache                               | last_policy_cache_update_time       |
| dm_external_policy_cache                               | last_pull_type                      |
| dm_external_policy_cache                               | last_pull_type_desc                 |
| dm_external_policy_cache                               | number_of_cached_policies           |
| dm_external_policy_cache                               | policy_cache_state                  |
| dm_external_policy_cache                               | policy_cache_state_desc             |
| dm_os_out_of_memory_events                             | allocation_potential_memory_mb      |
| dm_os_out_of_memory_events                             | available_physical_memory_mb        |
| dm_os_out_of_memory_events                             | committed_memory_mb                 |
| dm_os_out_of_memory_events                             | committed_memory_target_mb          |
| dm_os_out_of_memory_events                             | current_job_object_memory_limit_mb  |
| dm_os_out_of_memory_events                             | event_time                          |
| dm_os_out_of_memory_events                             | initial_job_object_memory_limit_mb  |
| dm_os_out_of_memory_events                             | non_sos_memory_usage_mb             |
| dm_os_out_of_memory_events                             | oom_cause                           |
| dm_os_out_of_memory_events                             | oom_cause_desc                      |
| dm_os_out_of_memory_events                             | oom_factor                          |
| dm_os_out_of_memory_events                             | oom_factor_desc                     |
| dm_os_out_of_memory_events                             | oom_resource_pools                  |
| dm_os_out_of_memory_events                             | possible_leaked_memory_clerks       |
| dm_os_out_of_memory_events                             | possible_non_sos_leaked_memory_mb   |
| dm_os_out_of_memory_events                             | process_memory_usage_mb             |
| dm_os_out_of_memory_events                             | top_memory_clerks                   |
| dm_os_out_of_memory_events                             | top_resource_pools                  |
| dm_request_phases                                      | avg_rows                            |
| dm_request_phases                                      | avg_time_ms                         |
| dm_request_phases                                      | dist_request_id                     |
| dm_request_phases                                      | dist_statement_id                   |
| dm_request_phases                                      | end_time                            |
| dm_request_phases                                      | error_id                            |
| dm_request_phases                                      | id                                  |
| dm_request_phases                                      | input_dop                           |
| dm_request_phases                                      | max_rows                            |
| dm_request_phases                                      | max_time_ms                         |
| dm_request_phases                                      | min_rows                            |
| dm_request_phases                                      | min_time_ms                         |
| dm_request_phases                                      | operation_type                      |
| dm_request_phases                                      | output_dop                          |
| dm_request_phases                                      | parent_ids                          |
| dm_request_phases                                      | start_time                          |
| dm_request_phases                                      | state_desc                          |
| dm_request_phases                                      | stdev_rows                          |
| dm_request_phases                                      | stdev_time_ms                       |
| dm_request_phases                                      | task_retries                        |
| dm_request_phases                                      | total_bytes_processed               |
| dm_request_phases                                      | total_elapsed_time_ms               |
| dm_request_phases                                      | total_rows                          |
| dm_request_phases_exec_task_stats                      | avg_rows                            |
| dm_request_phases_exec_task_stats                      | avg_time_ms                         |
| dm_request_phases_exec_task_stats                      | dist_request_id                     |
| dm_request_phases_exec_task_stats                      | error_id                            |
| dm_request_phases_exec_task_stats                      | id                                  |
| dm_request_phases_exec_task_stats                      | max_rows                            |
| dm_request_phases_exec_task_stats                      | max_time_ms                         |
| dm_request_phases_exec_task_stats                      | min_rows                            |
| dm_request_phases_exec_task_stats                      | min_time_ms                         |
| dm_request_phases_exec_task_stats                      | stdev_rows                          |
| dm_request_phases_exec_task_stats                      | stdev_time_ms                       |
| dm_request_phases_exec_task_stats                      | total_bytes_processed               |
| dm_request_phases_exec_task_stats                      | total_rows                          |
| dm_request_phases_task_group_stats                     | dist_request_id                     |
| dm_request_phases_task_group_stats                     | dist_statement_id                   |
| dm_request_phases_task_group_stats                     | end_time                            |
| dm_request_phases_task_group_stats                     | id                                  |
| dm_request_phases_task_group_stats                     | input_dop                           |
| dm_request_phases_task_group_stats                     | operation_type                      |
| dm_request_phases_task_group_stats                     | output_dop                          |
| dm_request_phases_task_group_stats                     | parent_ids                          |
| dm_request_phases_task_group_stats                     | start_time                          |
| dm_request_phases_task_group_stats                     | state_desc                          |
| dm_request_phases_task_group_stats                     | task_retries                        |
| dm_server_external_policy_actions                      | action_namespace                    |
| dm_server_external_policy_actions                      | action_provider_string              |
| dm_server_external_policy_actions                      | action_type                         |
| dm_server_external_policy_actions                      | sql_action_id                       |
| dm_server_external_policy_principal_assigned_actions   | action_namespace                    |
| dm_server_external_policy_principal_assigned_actions   | action_type                         |
| dm_server_external_policy_principal_assigned_actions   | principal_aad_object_id             |
| dm_server_external_policy_principal_assigned_actions   | principal_sid                       |
| dm_server_external_policy_principal_assigned_actions   | role_assignment_scope               |
| dm_server_external_policy_principal_assigned_actions   | role_assignment_type                |
| dm_server_external_policy_principal_assigned_actions   | role_assignment_type_desc           |
| dm_server_external_policy_principal_assigned_actions   | role_guid                           |
| dm_server_external_policy_principal_assigned_actions   | role_name                           |
| dm_server_external_policy_principals                   | aad_object_id                       |
| dm_server_external_policy_principals                   | authentication_type                 |
| dm_server_external_policy_principals                   | authentication_type_desc            |
| dm_server_external_policy_principals                   | sid                                 |
| dm_server_external_policy_principals                   | type                                |
| dm_server_external_policy_principals                   | type_desc                           |
| dm_server_external_policy_role_actions                 | role_guid                           |
| dm_server_external_policy_role_actions                 | sql_action_id                       |
| dm_server_external_policy_role_members                 | assignment_scope                    |
| dm_server_external_policy_role_members                 | assignment_type                     |
| dm_server_external_policy_role_members                 | assignment_type_desc                |
| dm_server_external_policy_role_members                 | principal_aad_object_id             |
| dm_server_external_policy_role_members                 | role_guid                           |
| dm_server_external_policy_roles                        | modify_date                         |
| dm_server_external_policy_roles                        | role_guid                           |
| dm_server_external_policy_roles                        | role_name                           |
| dm_server_hardware_offload_config                      | config                              |
| dm_server_hardware_offload_config                      | config_in_use                       |
| dm_server_hardware_offload_config                      | hardware_offload                    |
| dm_server_hardware_offload_config                      | is_loaded                           |
| dm_server_hardware_offload_config                      | is_loaded_desc                      |
| dm_server_suspend_status                               | db_id                               |
| dm_server_suspend_status                               | db_name                             |
| dm_server_suspend_status                               | is_diffmap_cleared                  |
| dm_server_suspend_status                               | is_writeio_frozen                   |
| dm_server_suspend_status                               | suspend_session_id                  |
| dm_server_suspend_status                               | suspend_time_ms                     |
| dm_toad_tuning_zones                                   | actions_discovered                  |
| dm_toad_tuning_zones                                   | actions_scheduled                   |
| dm_toad_tuning_zones                                   | entry_data                          |
| dm_toad_tuning_zones                                   | priority_score                      |
| dm_toad_tuning_zones                                   | total_actions_scheduled             |
| dm_toad_tuning_zones                                   | zone_type                           |
| dm_toad_work_item_handlers                             | message_id                          |
| dm_toad_work_item_handlers                             | producer_id                         |
| dm_toad_work_item_handlers                             | producer_type                       |
| dm_toad_work_item_handlers                             | state                               |
| dm_toad_work_item_handlers                             | task_address                        |
| dm_toad_work_item_handlers                             | workitem_type                       |
| dm_toad_work_items                                     | body_size                           |
| dm_toad_work_items                                     | message_id                          |
| dm_toad_work_items                                     | producer_id                         |
| dm_toad_work_items                                     | producer_type                       |
| dm_toad_work_items                                     | retry_count                         |
| dm_toad_work_items                                     | workitem_type                       |
| dm_toad_work_items                                     | workitem_version                    |
| dm_xcs_enumerate_blobdirectory                         | container_path                      |
| dm_xcs_enumerate_blobdirectory                         | etag                                |
| dm_xcs_enumerate_blobdirectory                         | last_modified_date                  |
| dm_xcs_enumerate_blobdirectory                         | part_key_name                       |
| dm_xcs_enumerate_blobdirectory                         | part_key_val                        |
| dm_xcs_enumerate_blobdirectory                         | relative_path                       |
| dm_xcs_enumerate_blobdirectory                         | size_in_bytes                       |
| external_job_streams                                   | is_input                            |
| external_job_streams                                   | is_output                           |
| external_job_streams                                   | job_id                              |
| external_job_streams                                   | stream_id                           |
| external_libraries_installed_table                     | db_id                               |
| external_libraries_installed_table                     | external_library_id                 |
| external_libraries_installed_table                     | language_id                         |
| external_libraries_installed_table                     | mdversion                           |
| external_libraries_installed_table                     | name                                |
| external_libraries_installed_table                     | principal_id                        |
| external_stream_columns                                | column_id                           |
| external_stream_columns                                | object_id                           |
| external_streaming_jobs                                | create_date                         |
| external_streaming_jobs                                | is_ms_shipped                       |
| external_streaming_jobs                                | is_published                        |
| external_streaming_jobs                                | is_schema_published                 |
| external_streaming_jobs                                | modify_date                         |
| external_streaming_jobs                                | name                                |
| external_streaming_jobs                                | object_id                           |
| external_streaming_jobs                                | parent_object_id                    |
| external_streaming_jobs                                | principal_id                        |
| external_streaming_jobs                                | schema_id                           |
| external_streaming_jobs                                | statement                           |
| external_streaming_jobs                                | status                              |
| external_streaming_jobs                                | type                                |
| external_streaming_jobs                                | type_desc                           |
| external_streaming_jobs                                | uses_ansi_nulls                     |
| external_streams                                       | create_date                         |
| external_streams                                       | data_source_id                      |
| external_streams                                       | file_format_id                      |
| external_streams                                       | input_options                       |
| external_streams                                       | is_ms_shipped                       |
| external_streams                                       | is_published                        |
| external_streams                                       | is_schema_published                 |
| external_streams                                       | location                            |
| external_streams                                       | max_column_id_used                  |
| external_streams                                       | modify_date                         |
| external_streams                                       | name                                |
| external_streams                                       | object_id                           |
| external_streams                                       | output_options                      |
| external_streams                                       | parent_object_id                    |
| external_streams                                       | principal_id                        |
| external_streams                                       | schema_id                           |
| external_streams                                       | type                                |
| external_streams                                       | type_desc                           |
| external_streams                                       | uses_ansi_nulls                     |
| external_table_partitioning_columns                    | column_id                           |
| external_table_partitioning_columns                    | object_id                           |
| external_table_partitioning_columns                    | ordinal_id                          |
| extgov_attribute_sync_state                            | current_blob_references             |
| extgov_attribute_sync_state                            | current_sync_token                  |
| extgov_attribute_sync_state                            | database_id                         |
| extgov_attribute_sync_state                            | database_name                       |
| extgov_attribute_sync_state                            | last_blob_fetch_attempt             |
| extgov_attribute_sync_state                            | last_blob_fetch_error               |
| extgov_attribute_sync_state                            | last_blob_fetch_success             |
| extgov_attribute_sync_state                            | last_ref_fetch_attempt              |
| extgov_attribute_sync_state                            | last_ref_fetch_error                |
| extgov_attribute_sync_state                            | last_ref_fetch_success              |
| extgov_attribute_sync_state                            | last_sync_success                   |
| extgov_attribute_sync_state                            | last_synchronizing_attempt          |
| extgov_attribute_sync_state                            | last_synchronizing_error            |
| extgov_attribute_sync_state                            | last_synchronizing_success          |
| extgov_attribute_sync_state                            | next_sync_token                     |
| extgov_attribute_sync_state                            | state                               |
| extgov_attribute_sync_state                            | state_desc                          |
| extgov_attribute_sync_tables_synchronizing             | last_fetch                          |
| extgov_attribute_sync_tables_synchronizing             | last_synchronizing_attempt          |
| extgov_attribute_sync_tables_synchronizing             | last_synchronizing_error            |
| extgov_attribute_sync_tables_synchronizing             | schema_id                           |
| extgov_attribute_sync_tables_synchronizing             | schema_name                         |
| extgov_attribute_sync_tables_synchronizing             | table_id                            |
| extgov_attribute_sync_tables_synchronizing             | table_name                          |
| fn_filelog                                             | AllocUnitId                         |
| fn_filelog                                             | AllocUnitName                       |
| fn_filelog                                             | Article ID                          |
| fn_filelog                                             | Begin Time                          |
| fn_filelog                                             | Beginlog Status                     |
| fn_filelog                                             | Bulk allocated extent count         |
| fn_filelog                                             | Bulk allocated extent ids           |
| fn_filelog                                             | Bulk allocation first IAM Page ID   |
| fn_filelog                                             | Bulk AllocUnitId                    |
| fn_filelog                                             | Bulk RowsetId                       |
| fn_filelog                                             | Byte Offset                         |
| fn_filelog                                             | Bytes Freed                         |
| fn_filelog                                             | Checkpoint Begin                    |
| fn_filelog                                             | Checkpoint End                      |
| fn_filelog                                             | CHKPT Begin DB Version              |
| fn_filelog                                             | CHKPT End DB Version                |
| fn_filelog                                             | CI Index Id                         |
| fn_filelog                                             | CI Table Id                         |
| fn_filelog                                             | Column Offset                       |
| fn_filelog                                             | Command                             |
| fn_filelog                                             | Command Type                        |
| fn_filelog                                             | Compression Info                    |
| fn_filelog                                             | Compression Log Type                |
| fn_filelog                                             | Context                             |
| fn_filelog                                             | CopyVerionInfo Source Page Id       |
| fn_filelog                                             | CopyVerionInfo Source Page LSN      |
| fn_filelog                                             | CopyVerionInfo Source Slot Count    |
| fn_filelog                                             | CopyVerionInfo Source Slot Id       |
| fn_filelog                                             | Current LSN                         |
| fn_filelog                                             | Database Name                       |
| fn_filelog                                             | Description                         |
| fn_filelog                                             | Dirty Pages                         |
| fn_filelog                                             | End AGE                             |
| fn_filelog                                             | End Time                            |
| fn_filelog                                             | File ID                             |
| fn_filelog                                             | File Status                         |
| fn_filelog                                             | FileGroup ID                        |
| fn_filelog                                             | Flag Bits                           |
| fn_filelog                                             | Flags                               |
| fn_filelog                                             | Format LSN                          |
| fn_filelog                                             | InvalidateCache Id                  |
| fn_filelog                                             | InvalidateCache keys                |
| fn_filelog                                             | Last Distributed Backup End LSN     |
| fn_filelog                                             | Last Distributed End LSN            |
| fn_filelog                                             | Lock Information                    |
| fn_filelog                                             | Log Record                          |
| fn_filelog                                             | Log Record Fixed Length             |
| fn_filelog                                             | Log Record Length                   |
| fn_filelog                                             | Log Reserve                         |
| fn_filelog                                             | LogBlockGeneration                  |
| fn_filelog                                             | Logical Name                        |
| fn_filelog                                             | LSN before writes                   |
| fn_filelog                                             | Mark Name                           |
| fn_filelog                                             | Master DBID                         |
| fn_filelog                                             | Master XDESID                       |
| fn_filelog                                             | Max XDESID                          |
| fn_filelog                                             | Meta Status                         |
| fn_filelog                                             | Minimum LSN                         |
| fn_filelog                                             | Modify Size                         |
| fn_filelog                                             | New Size                            |
| fn_filelog                                             | New Split Page                      |
| fn_filelog                                             | New Value                           |
| fn_filelog                                             | NewAllocUnitId                      |
| fn_filelog                                             | Next Replicated End LSN             |
| fn_filelog                                             | Num Elements                        |
| fn_filelog                                             | Num Transactions                    |
| fn_filelog                                             | Number of Locks                     |
| fn_filelog                                             | Offset                              |
| fn_filelog                                             | Offset in Row                       |
| fn_filelog                                             | Old Size                            |
| fn_filelog                                             | Old Value                           |
| fn_filelog                                             | Oldest Active LSN                   |
| fn_filelog                                             | Oldest Active Transaction ID        |
| fn_filelog                                             | Oldest Replicated Begin LSN         |
| fn_filelog                                             | Operation                           |
| fn_filelog                                             | Page ID                             |
| fn_filelog                                             | PageFormat FormatOption             |
| fn_filelog                                             | PageFormat PageFlags                |
| fn_filelog                                             | PageFormat PageLevel                |
| fn_filelog                                             | PageFormat PageStat                 |
| fn_filelog                                             | PageFormat PageType                 |
| fn_filelog                                             | Pages Written                       |
| fn_filelog                                             | Parent Transaction ID               |
| fn_filelog                                             | Partial Status                      |
| fn_filelog                                             | PartitionId                         |
| fn_filelog                                             | Physical Name                       |
| fn_filelog                                             | Prepare Time                        |
| fn_filelog                                             | Preplog Begin LSN                   |
| fn_filelog                                             | Previous LSN                        |
| fn_filelog                                             | Previous Page LSN                   |
| fn_filelog                                             | Previous Savepoint                  |
| fn_filelog                                             | Publication ID                      |
| fn_filelog                                             | Repl Min Hold LSN                   |
| fn_filelog                                             | Replicated Records                  |
| fn_filelog                                             | Rowbits Bit Count                   |
| fn_filelog                                             | Rowbits Bit Value                   |
| fn_filelog                                             | Rowbits First Bit                   |
| fn_filelog                                             | RowFlags                            |
| fn_filelog                                             | RowLog Contents 0                   |
| fn_filelog                                             | RowLog Contents 1                   |
| fn_filelog                                             | RowLog Contents 2                   |
| fn_filelog                                             | RowLog Contents 3                   |
| fn_filelog                                             | RowLog Contents 4                   |
| fn_filelog                                             | RowLog Contents 5                   |
| fn_filelog                                             | Rows Deleted                        |
| fn_filelog                                             | RowsetId                            |
| fn_filelog                                             | Savepoint Name                      |
| fn_filelog                                             | Server Name                         |
| fn_filelog                                             | Server UID                          |
| fn_filelog                                             | Slot ID                             |
| fn_filelog                                             | SPID                                |
| fn_filelog                                             | Tag Bits                            |
| fn_filelog                                             | Text Size                           |
| fn_filelog                                             | TextPtr                             |
| fn_filelog                                             | Transaction Begin                   |
| fn_filelog                                             | Transaction ID                      |
| fn_filelog                                             | Transaction Name                    |
| fn_filelog                                             | Transaction SID                     |
| fn_filelog                                             | Virtual Clock                       |
| fn_filelog                                             | VLFs added                          |
| fn_filelog                                             | Xact ID                             |
| fn_filelog                                             | Xact Node ID                        |
| fn_filelog                                             | Xact Node Local ID                  |
| fn_filelog                                             | Xact Type                           |
| fn_ledger_retrieve_digests_from_url                    | digest                              |
| fn_xcs_get_file_rowcount                               | row_count                           |
| ledger_column_history                                  | column_id                           |
| ledger_column_history                                  | column_name                         |
| ledger_column_history                                  | object_id                           |
| ledger_column_history                                  | operation_type                      |
| ledger_column_history                                  | operation_type_desc                 |
| ledger_column_history                                  | sequence_number                     |
| ledger_column_history                                  | transaction_id                      |
| ledger_columns_history_internal                        | column_id                           |
| ledger_columns_history_internal                        | column_name                         |
| ledger_columns_history_internal                        | ledger_end_sequence_number          |
| ledger_columns_history_internal                        | ledger_end_transaction_id           |
| ledger_columns_history_internal                        | ledger_start_sequence_number        |
| ledger_columns_history_internal                        | ledger_start_transaction_id         |
| ledger_columns_history_internal                        | object_id                           |
| ledger_columns_history_internal                        | operation_type                      |
| ledger_columns_history_internal_history                | column_id                           |
| ledger_columns_history_internal_history                | column_name                         |
| ledger_columns_history_internal_history                | ledger_end_sequence_number          |
| ledger_columns_history_internal_history                | ledger_end_transaction_id           |
| ledger_columns_history_internal_history                | ledger_start_sequence_number        |
| ledger_columns_history_internal_history                | ledger_start_transaction_id         |
| ledger_columns_history_internal_history                | object_id                           |
| ledger_columns_history_internal_history                | operation_type                      |
| ledger_table_history                                   | ledger_view_name                    |
| ledger_table_history                                   | ledger_view_schema_name             |
| ledger_table_history                                   | object_id                           |
| ledger_table_history                                   | operation_type                      |
| ledger_table_history                                   | operation_type_desc                 |
| ledger_table_history                                   | schema_name                         |
| ledger_table_history                                   | sequence_number                     |
| ledger_table_history                                   | table_name                          |
| ledger_table_history                                   | transaction_id                      |
| ledger_tables_history_internal                         | ledger_end_sequence_number          |
| ledger_tables_history_internal                         | ledger_end_transaction_id           |
| ledger_tables_history_internal                         | ledger_start_sequence_number        |
| ledger_tables_history_internal                         | ledger_start_transaction_id         |
| ledger_tables_history_internal                         | ledger_view_name                    |
| ledger_tables_history_internal                         | ledger_view_schema_name             |
| ledger_tables_history_internal                         | object_id                           |
| ledger_tables_history_internal                         | operation_type                      |
| ledger_tables_history_internal                         | operation_type_column_name          |
| ledger_tables_history_internal                         | operation_type_desc_column_name     |
| ledger_tables_history_internal                         | schema_name                         |
| ledger_tables_history_internal                         | sequence_number_column_name         |
| ledger_tables_history_internal                         | status                              |
| ledger_tables_history_internal                         | table_name                          |
| ledger_tables_history_internal                         | transaction_id_column_name          |
| ledger_tables_history_internal_history                 | ledger_end_sequence_number          |
| ledger_tables_history_internal_history                 | ledger_end_transaction_id           |
| ledger_tables_history_internal_history                 | ledger_start_sequence_number        |
| ledger_tables_history_internal_history                 | ledger_start_transaction_id         |
| ledger_tables_history_internal_history                 | ledger_view_name                    |
| ledger_tables_history_internal_history                 | ledger_view_schema_name             |
| ledger_tables_history_internal_history                 | object_id                           |
| ledger_tables_history_internal_history                 | operation_type                      |
| ledger_tables_history_internal_history                 | operation_type_column_name          |
| ledger_tables_history_internal_history                 | operation_type_desc_column_name     |
| ledger_tables_history_internal_history                 | schema_name                         |
| ledger_tables_history_internal_history                 | sequence_number_column_name         |
| ledger_tables_history_internal_history                 | status                              |
| ledger_tables_history_internal_history                 | table_name                          |
| ledger_tables_history_internal_history                 | transaction_id_column_name          |
| plan_persist_plan_feedback                             | create_time                         |
| plan_persist_plan_feedback                             | feature_id                          |
| plan_persist_plan_feedback                             | feedback_data                       |
| plan_persist_plan_feedback                             | last_updated_time                   |
| plan_persist_plan_feedback                             | plan_feedback_id                    |
| plan_persist_plan_feedback                             | plan_id                             |
| plan_persist_plan_feedback                             | state                               |
| plan_persist_plan_forcing_locations                    | plan_forcing_location_id            |
| plan_persist_plan_forcing_locations                    | plan_id                             |
| plan_persist_plan_forcing_locations                    | query_id                            |
| plan_persist_plan_forcing_locations                    | replica_group_id                    |
| plan_persist_query_variant                             | dispatcher_plan_id                  |
| plan_persist_query_variant                             | parent_query_id                     |
| plan_persist_query_variant                             | query_variant_query_id              |
| plan_persist_replicas                                  | replica_group_id                    |
| plan_persist_replicas                                  | replica_name                        |
| plan_persist_replicas                                  | role_type                           |
| plan_persist_runtime_stats_v2                          | count_executions                    |
| plan_persist_runtime_stats_v2                          | execution_type                      |
| plan_persist_runtime_stats_v2                          | first_execution_time                |
| plan_persist_runtime_stats_v2                          | last_clr_time                       |
| plan_persist_runtime_stats_v2                          | last_cpu_time                       |
| plan_persist_runtime_stats_v2                          | last_dop                            |
| plan_persist_runtime_stats_v2                          | last_duration                       |
| plan_persist_runtime_stats_v2                          | last_execution_time                 |
| plan_persist_runtime_stats_v2                          | last_log_bytes_used                 |
| plan_persist_runtime_stats_v2                          | last_logical_io_reads               |
| plan_persist_runtime_stats_v2                          | last_logical_io_writes              |
| plan_persist_runtime_stats_v2                          | last_num_physical_io_reads          |
| plan_persist_runtime_stats_v2                          | last_page_server_io_reads           |
| plan_persist_runtime_stats_v2                          | last_physical_io_reads              |
| plan_persist_runtime_stats_v2                          | last_query_max_used_memory          |
| plan_persist_runtime_stats_v2                          | last_rowcount                       |
| plan_persist_runtime_stats_v2                          | last_tempdb_space_used              |
| plan_persist_runtime_stats_v2                          | max_clr_time                        |
| plan_persist_runtime_stats_v2                          | max_cpu_time                        |
| plan_persist_runtime_stats_v2                          | max_dop                             |
| plan_persist_runtime_stats_v2                          | max_duration                        |
| plan_persist_runtime_stats_v2                          | max_log_bytes_used                  |
| plan_persist_runtime_stats_v2                          | max_logical_io_reads                |
| plan_persist_runtime_stats_v2                          | max_logical_io_writes               |
| plan_persist_runtime_stats_v2                          | max_num_physical_io_reads           |
| plan_persist_runtime_stats_v2                          | max_page_server_io_reads            |
| plan_persist_runtime_stats_v2                          | max_physical_io_reads               |
| plan_persist_runtime_stats_v2                          | max_query_max_used_memory           |
| plan_persist_runtime_stats_v2                          | max_rowcount                        |
| plan_persist_runtime_stats_v2                          | max_tempdb_space_used               |
| plan_persist_runtime_stats_v2                          | min_clr_time                        |
| plan_persist_runtime_stats_v2                          | min_cpu_time                        |
| plan_persist_runtime_stats_v2                          | min_dop                             |
| plan_persist_runtime_stats_v2                          | min_duration                        |
| plan_persist_runtime_stats_v2                          | min_log_bytes_used                  |
| plan_persist_runtime_stats_v2                          | min_logical_io_reads                |
| plan_persist_runtime_stats_v2                          | min_logical_io_writes               |
| plan_persist_runtime_stats_v2                          | min_num_physical_io_reads           |
| plan_persist_runtime_stats_v2                          | min_page_server_io_reads            |
| plan_persist_runtime_stats_v2                          | min_physical_io_reads               |
| plan_persist_runtime_stats_v2                          | min_query_max_used_memory           |
| plan_persist_runtime_stats_v2                          | min_rowcount                        |
| plan_persist_runtime_stats_v2                          | min_tempdb_space_used               |
| plan_persist_runtime_stats_v2                          | plan_id                             |
| plan_persist_runtime_stats_v2                          | replica_group_id                    |
| plan_persist_runtime_stats_v2                          | runtime_stats_id                    |
| plan_persist_runtime_stats_v2                          | runtime_stats_interval_id           |
| plan_persist_runtime_stats_v2                          | sumsquare_clr_time                  |
| plan_persist_runtime_stats_v2                          | sumsquare_cpu_time                  |
| plan_persist_runtime_stats_v2                          | sumsquare_dop                       |
| plan_persist_runtime_stats_v2                          | sumsquare_duration                  |
| plan_persist_runtime_stats_v2                          | sumsquare_log_bytes_used            |
| plan_persist_runtime_stats_v2                          | sumsquare_logical_io_reads          |
| plan_persist_runtime_stats_v2                          | sumsquare_logical_io_writes         |
| plan_persist_runtime_stats_v2                          | sumsquare_num_physical_io_reads     |
| plan_persist_runtime_stats_v2                          | sumsquare_page_server_io_reads      |
| plan_persist_runtime_stats_v2                          | sumsquare_physical_io_reads         |
| plan_persist_runtime_stats_v2                          | sumsquare_query_max_used_memory     |
| plan_persist_runtime_stats_v2                          | sumsquare_rowcount                  |
| plan_persist_runtime_stats_v2                          | sumsquare_tempdb_space_used         |
| plan_persist_runtime_stats_v2                          | total_clr_time                      |
| plan_persist_runtime_stats_v2                          | total_cpu_time                      |
| plan_persist_runtime_stats_v2                          | total_dop                           |
| plan_persist_runtime_stats_v2                          | total_duration                      |
| plan_persist_runtime_stats_v2                          | total_log_bytes_used                |
| plan_persist_runtime_stats_v2                          | total_logical_io_reads              |
| plan_persist_runtime_stats_v2                          | total_logical_io_writes             |
| plan_persist_runtime_stats_v2                          | total_num_physical_io_reads         |
| plan_persist_runtime_stats_v2                          | total_page_server_io_reads          |
| plan_persist_runtime_stats_v2                          | total_physical_io_reads             |
| plan_persist_runtime_stats_v2                          | total_query_max_used_memory         |
| plan_persist_runtime_stats_v2                          | total_rowcount                      |
| plan_persist_runtime_stats_v2                          | total_tempdb_space_used             |
| plan_persist_wait_stats_v2                             | count_executions                    |
| plan_persist_wait_stats_v2                             | execution_type                      |
| plan_persist_wait_stats_v2                             | last_query_wait_time_ms             |
| plan_persist_wait_stats_v2                             | max_query_wait_time_ms              |
| plan_persist_wait_stats_v2                             | min_query_wait_time_ms              |
| plan_persist_wait_stats_v2                             | plan_id                             |
| plan_persist_wait_stats_v2                             | replica_group_id                    |
| plan_persist_wait_stats_v2                             | runtime_stats_interval_id           |
| plan_persist_wait_stats_v2                             | sumsquare_query_wait_time_ms        |
| plan_persist_wait_stats_v2                             | total_query_wait_time_ms            |
| plan_persist_wait_stats_v2                             | wait_category                       |
| plan_persist_wait_stats_v2                             | wait_stats_id                       |
| polaris_executed_requests_history                      | command                             |
| polaris_executed_requests_history                      | data_processed_mb                   |
| polaris_executed_requests_history                      | distributed_statement_id            |
| polaris_executed_requests_history                      | end_time                            |
| polaris_executed_requests_history                      | error                               |
| polaris_executed_requests_history                      | error_code                          |
| polaris_executed_requests_history                      | id                                  |
| polaris_executed_requests_history                      | login_name                          |
| polaris_executed_requests_history                      | query_hash                          |
| polaris_executed_requests_history                      | query_info                          |
| polaris_executed_requests_history                      | rejected_rows_path                  |
| polaris_executed_requests_history                      | sql_handle                          |
| polaris_executed_requests_history                      | start_time                          |
| polaris_executed_requests_history                      | statement_offset_end                |
| polaris_executed_requests_history                      | statement_offset_start              |
| polaris_executed_requests_history                      | status                              |
| polaris_executed_requests_history                      | total_elapsed_time_ms               |
| polaris_executed_requests_history                      | transaction_id                      |
| polaris_executed_requests_text                         | id                                  |
| polaris_executed_requests_text                         | last_access                         |
| polaris_executed_requests_text                         | sql_handle                          |
| polaris_executed_requests_text                         | sql_text                            |
| polaris_file_cache_entries                             | file_id                             |
| polaris_file_cache_entries                             | file_path                           |
| polaris_file_cache_entries                             | file_version                        |
| polaris_file_cache_streams                             | file_id                             |
| polaris_file_cache_streams                             | stream_key                          |
| polaris_file_cache_streams                             | stream_offset                       |
| polaris_file_cache_streams                             | stream_size                         |
| polaris_file_statistics                                | access_date                         |
| polaris_file_statistics                                | additional_props                    |
| polaris_file_statistics                                | hash_key                            |
| polaris_file_statistics                                | is_auto                             |
| polaris_file_statistics                                | source_props                        |
| polaris_file_statistics                                | stats_blob                          |
| query_store_plan_feedback                              | create_time                         |
| query_store_plan_feedback                              | feature_desc                        |
| query_store_plan_feedback                              | feature_id                          |
| query_store_plan_feedback                              | feedback_data                       |
| query_store_plan_feedback                              | last_updated_time                   |
| query_store_plan_feedback                              | plan_feedback_id                    |
| query_store_plan_feedback                              | plan_id                             |
| query_store_plan_feedback                              | state                               |
| query_store_plan_feedback                              | state_desc                          |
| query_store_plan_forcing_locations                     | plan_forcing_location_id            |
| query_store_plan_forcing_locations                     | plan_id                             |
| query_store_plan_forcing_locations                     | query_id                            |
| query_store_plan_forcing_locations                     | replica_group_id                    |
| query_store_query_hints                                | comment                             |
| query_store_query_hints                                | last_query_hint_failure_reason      |
| query_store_query_hints                                | last_query_hint_failure_reason_desc |
| query_store_query_hints                                | query_hint_failure_count            |
| query_store_query_hints                                | query_hint_id                       |
| query_store_query_hints                                | query_hint_text                     |
| query_store_query_hints                                | query_id                            |
| query_store_query_hints                                | source                              |
| query_store_query_hints                                | source_desc                         |
| query_store_query_variant                              | dispatcher_plan_id                  |
| query_store_query_variant                              | parent_query_id                     |
| query_store_query_variant                              | query_variant_query_id              |
| query_store_replicas                                   | replica_group_id                    |
| query_store_replicas                                   | replica_name                        |
| query_store_replicas                                   | role_type                           |
| sql_pools_table                                        | alter_role_id                       |
| sql_pools_table                                        | auto_pause_timer                    |
| sql_pools_table                                        | connect_role_id                     |
| sql_pools_table                                        | create_date                         |
| sql_pools_table                                        | guid                                |
| sql_pools_table                                        | id                                  |
| sql_pools_table                                        | is_auto_resume_on                   |
| sql_pools_table                                        | is_result_set_caching_on            |
| sql_pools_table                                        | max_service_objective               |
| sql_pools_table                                        | modify_date                         |
| sql_pools_table                                        | name                                |
| sql_pools_table                                        | owner_id                            |
| sql_pools_table                                        | service_objective                   |
| sql_pools_table                                        | service_tier                        |
| sql_pools_table                                        | state                               |
+--------------------------------------------------------+-------------------------------------+

Thanks for reading!

Going Further


If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.