New System Objects In SQL Server 2022

Today!


SQL Server 2022 was released today, so I’m digging around looking for new stuff. I’ll provide what details I can as I go, but it’s brand new so 🤷‍♂️

Here’s a list of new system objects for you to speculate about!

+------------------------------------------------------------+----------------------------------+
|                            name                            |            type_desc             |
+------------------------------------------------------------+----------------------------------+
| backup_metadata_store                                      | INTERNAL_TABLE                   |
| database_ledger_blocks                                     | VIEW                             |
| database_ledger_digest_locations                           | VIEW                             |
| database_ledger_transactions                               | VIEW                             |
| database_query_store_internal_state                        | VIEW                             |
| db_ledger_blocks                                           | INTERNAL_TABLE                   |
| db_ledger_digest_locations                                 | INTERNAL_TABLE                   |
| db_ledger_transactions                                     | INTERNAL_TABLE                   |
| dm_change_feed_errors                                      | VIEW                             |
| dm_change_feed_log_scan_sessions                           | VIEW                             |
| dm_column_encryption_enclave_properties                    | VIEW                             |
| dm_database_backups                                        | VIEW                             |
| dm_database_external_policy_actions                        | VIEW                             |
| dm_database_external_policy_principal_assigned_actions     | VIEW                             |
| dm_database_external_policy_principals                     | VIEW                             |
| dm_database_external_policy_role_actions                   | VIEW                             |
| dm_database_external_policy_role_members                   | VIEW                             |
| dm_database_external_policy_roles                          | VIEW                             |
| dm_dist_requests                                           | VIEW                             |
| dm_dw_databases                                            | VIEW                             |
| dm_dw_locks                                                | VIEW                             |
| dm_dw_pit_databases                                        | VIEW                             |
| dm_dw_quality_clustering                                   | VIEW                             |
| dm_dw_quality_delta                                        | VIEW                             |
| dm_dw_quality_index                                        | VIEW                             |
| dm_dw_quality_row_group                                    | VIEW                             |
| dm_dw_resource_manager_abort_cache                         | VIEW                             |
| dm_dw_resource_manager_active_tran                         | VIEW                             |
| dm_dw_tran_manager_abort_cache                             | VIEW                             |
| dm_dw_tran_manager_active_cache                            | VIEW                             |
| dm_dw_tran_manager_commit_cache                            | VIEW                             |
| dm_exec_requests_history                                   | VIEW                             |
| dm_external_data_processed                                 | VIEW                             |
| dm_external_policy_cache                                   | VIEW                             |
| dm_os_out_of_memory_events                                 | VIEW                             |
| dm_request_phases                                          | VIEW                             |
| dm_request_phases_exec_task_stats                          | VIEW                             |
| dm_request_phases_task_group_stats                         | VIEW                             |
| dm_server_external_policy_actions                          | VIEW                             |
| dm_server_external_policy_principal_assigned_actions       | VIEW                             |
| dm_server_external_policy_principals                       | VIEW                             |
| dm_server_external_policy_role_actions                     | VIEW                             |
| dm_server_external_policy_role_members                     | VIEW                             |
| dm_server_external_policy_roles                            | VIEW                             |
| dm_server_hardware_offload_config                          | VIEW                             |
| dm_server_suspend_status                                   | VIEW                             |
| dm_toad_tuning_zones                                       | VIEW                             |
| dm_toad_work_item_handlers                                 | VIEW                             |
| dm_toad_work_items                                         | VIEW                             |
| dm_xcs_enumerate_blobdirectory                             | SQL_INLINE_TABLE_VALUED_FUNCTION |
| external_job_streams                                       | VIEW                             |
| external_libraries_installed_table                         | INTERNAL_TABLE                   |
| external_stream_columns                                    | VIEW                             |
| external_streaming_jobs                                    | VIEW                             |
| external_streams                                           | VIEW                             |
| external_table_partitioning_columns                        | VIEW                             |
| extgov_attribute_sync_state                                | VIEW                             |
| extgov_attribute_sync_tables_synchronizing                 | VIEW                             |
| fn_cdc_is_ddl_handling_enabled                             | SQL_SCALAR_FUNCTION              |
| fn_filelog                                                 | SQL_INLINE_TABLE_VALUED_FUNCTION |
| fn_ledger_retrieve_digests_from_url                        | SQL_INLINE_TABLE_VALUED_FUNCTION |
| fn_xcs_get_file_rowcount                                   | SQL_INLINE_TABLE_VALUED_FUNCTION |
| ledger_column_history                                      | VIEW                             |
| ledger_columns_history_internal                            | INTERNAL_TABLE                   |
| ledger_columns_history_internal_history                    | INTERNAL_TABLE                   |
| ledger_table_history                                       | VIEW                             |
| ledger_tables_history_internal                             | INTERNAL_TABLE                   |
| ledger_tables_history_internal_history                     | INTERNAL_TABLE                   |
| PK_Sql_Pools_Table_Id                                      | PRIMARY_KEY_CONSTRAINT           |
| plan_persist_plan_feedback                                 | INTERNAL_TABLE                   |
| plan_persist_plan_forcing_locations                        | INTERNAL_TABLE                   |
| plan_persist_query_variant                                 | INTERNAL_TABLE                   |
| plan_persist_replicas                                      | INTERNAL_TABLE                   |
| plan_persist_runtime_stats_v2                              | INTERNAL_TABLE                   |
| plan_persist_wait_stats_v2                                 | INTERNAL_TABLE                   |
| polaris_executed_requests_history                          | INTERNAL_TABLE                   |
| polaris_executed_requests_text                             | INTERNAL_TABLE                   |
| polaris_file_cache_entries                                 | INTERNAL_TABLE                   |
| polaris_file_cache_streams                                 | INTERNAL_TABLE                   |
| polaris_file_statistics                                    | INTERNAL_TABLE                   |
| query_store_plan_feedback                                  | VIEW                             |
| query_store_plan_forcing_locations                         | VIEW                             |
| query_store_query_hints                                    | VIEW                             |
| query_store_query_variant                                  | VIEW                             |
| query_store_replicas                                       | VIEW                             |
| sp_cdc_set_scheduler_job                                   | EXTENDED_STORED_PROCEDURE        |
| sp_change_feed_create_table_group                          | SQL_STORED_PROCEDURE             |
| sp_change_feed_disable_db                                  | SQL_STORED_PROCEDURE             |
| sp_change_feed_disable_table                               | SQL_STORED_PROCEDURE             |
| sp_change_feed_drop_table_group                            | SQL_STORED_PROCEDURE             |
| sp_change_feed_enable_db                                   | SQL_STORED_PROCEDURE             |
| sp_change_feed_enable_table                                | SQL_STORED_PROCEDURE             |
| sp_change_feed_vupgrade                                    | SQL_STORED_PROCEDURE             |
| sp_cleanup_all_average_column_length_statistics            | EXTENDED_STORED_PROCEDURE        |
| sp_cleanup_all_openrowset_statistics                       | EXTENDED_STORED_PROCEDURE        |
| sp_cleanup_all_user_data_in_master                         | EXTENDED_STORED_PROCEDURE        |
| sp_cleanup_data_retention                                  | SQL_STORED_PROCEDURE             |
| sp_collect_backend_plan                                    | EXTENDED_STORED_PROCEDURE        |
| sp_copy_data_in_batches                                    | EXTENDED_STORED_PROCEDURE        |
| sp_create_format_type                                      | EXTENDED_STORED_PROCEDURE        |
| sp_create_format_type_synonym                              | EXTENDED_STORED_PROCEDURE        |
| sp_create_openrowset_statistics                            | EXTENDED_STORED_PROCEDURE        |
| sp_create_parser_version                                   | EXTENDED_STORED_PROCEDURE        |
| sp_create_streaming_job                                    | SQL_STORED_PROCEDURE             |
| sp_delete_database_engine_configuration_internal           | EXTENDED_STORED_PROCEDURE        |
| sp_discover_trident_table                                  | SQL_STORED_PROCEDURE             |
| sp_drop_format_type                                        | EXTENDED_STORED_PROCEDURE        |
| sp_drop_openrowset_statistics                              | EXTENDED_STORED_PROCEDURE        |
| sp_drop_parser_version                                     | EXTENDED_STORED_PROCEDURE        |
| sp_drop_storage_location                                   | EXTENDED_STORED_PROCEDURE        |
| sp_drop_streaming_job                                      | SQL_STORED_PROCEDURE             |
| sp_drop_trident_data_location                              | SQL_STORED_PROCEDURE             |
| sp_execute_flight_query                                    | EXTENDED_STORED_PROCEDURE        |
| sp_executesql_metrics                                      | EXTENDED_STORED_PROCEDURE        |
| sp_external_policy_refresh                                 | EXTENDED_STORED_PROCEDURE        |
| sp_fido_build_basic_histogram                              | EXTENDED_STORED_PROCEDURE        |
| sp_fido_build_histogram                                    | EXTENDED_STORED_PROCEDURE        |
| sp_fido_execute_graph_request                              | EXTENDED_STORED_PROCEDURE        |
| sp_fido_get_CS_rowset_row_count                            | EXTENDED_STORED_PROCEDURE        |
| sp_fido_get_remote_storage_size                            | EXTENDED_STORED_PROCEDURE        |
| sp_fido_glm_server_execute_batch                           | EXTENDED_STORED_PROCEDURE        |
| sp_fido_glms_get_storage_containers                        | EXTENDED_STORED_PROCEDURE        |
| sp_fido_glms_set_storage_containers                        | EXTENDED_STORED_PROCEDURE        |
| sp_fido_glms_unregister_appname                            | EXTENDED_STORED_PROCEDURE        |
| sp_fido_indexstore_update_topology                         | EXTENDED_STORED_PROCEDURE        |
| sp_fido_indexstore_upgrade_node                            | EXTENDED_STORED_PROCEDURE        |
| sp_fido_remove_retention_policy                            | EXTENDED_STORED_PROCEDURE        |
| sp_fido_set_ddl_step                                       | EXTENDED_STORED_PROCEDURE        |
| sp_fido_set_retention_policy                               | EXTENDED_STORED_PROCEDURE        |
| sp_fido_setup_endpoints                                    | EXTENDED_STORED_PROCEDURE        |
| sp_fido_spaceused                                          | SQL_STORED_PROCEDURE             |
| sp_fido_tran_abort                                         | EXTENDED_STORED_PROCEDURE        |
| sp_fido_tran_begin                                         | EXTENDED_STORED_PROCEDURE        |
| sp_fido_tran_commit                                        | EXTENDED_STORED_PROCEDURE        |
| sp_fido_tran_get_state                                     | EXTENDED_STORED_PROCEDURE        |
| sp_fido_tran_set_token                                     | EXTENDED_STORED_PROCEDURE        |
| sp_generate_database_ledger_digest                         | SQL_STORED_PROCEDURE             |
| sp_generate_external_table_statistics_description_and_hash | EXTENDED_STORED_PROCEDURE        |
| sp_generate_openrowset_statistics_props                    | EXTENDED_STORED_PROCEDURE        |
| sp_generate_trident_table_manifest                         | EXTENDED_STORED_PROCEDURE        |
| sp_get_dmv_collector_views                                 | EXTENDED_STORED_PROCEDURE        |
| sp_get_external_table_cardinality                          | EXTENDED_STORED_PROCEDURE        |
| sp_get_fido_lock                                           | EXTENDED_STORED_PROCEDURE        |
| sp_get_fido_lock_batch                                     | EXTENDED_STORED_PROCEDURE        |
| sp_get_file_splits                                         | EXTENDED_STORED_PROCEDURE        |
| sp_get_migration_vlf_state                                 | EXTENDED_STORED_PROCEDURE        |
| sp_get_openrowset_statistics_additional_props              | EXTENDED_STORED_PROCEDURE        |
| sp_get_openrowset_statistics_cardinality                   | EXTENDED_STORED_PROCEDURE        |
| sp_get_streaming_job                                       | SQL_STORED_PROCEDURE             |
| sp_get_total_openrowset_statistics_count                   | EXTENDED_STORED_PROCEDURE        |
| sp_get_trident_data_location                               | SQL_STORED_PROCEDURE             |
| sp_help_change_feed                                        | SQL_STORED_PROCEDURE             |
| sp_invoke_external_rest_endpoint                           | SQL_STORED_PROCEDURE             |
| sp_ldw_apply_file_updates_for_ext_table                    | SQL_STORED_PROCEDURE             |
| sp_ldw_get_file_updates_for_ext_table                      | SQL_STORED_PROCEDURE             |
| sp_ldw_normalize_ext_tab_name                              | SQL_STORED_PROCEDURE             |
| sp_ldw_update_stats_for_ext_table                          | SQL_STORED_PROCEDURE             |
| sp_manage_msdtc_transaction                                | EXTENDED_STORED_PROCEDURE        |
| sp_memory_leak_detection                                   | SQL_STORED_PROCEDURE             |
| sp_metadata_sync_connector_add                             | SQL_STORED_PROCEDURE             |
| sp_metadata_sync_connector_drop                            | SQL_STORED_PROCEDURE             |
| sp_metadata_sync_connectors_status                         | SQL_STORED_PROCEDURE             |
| sp_MSchange_feed_ddl_event                                 | SQL_STORED_PROCEDURE             |
| sp_process_memory_leak_record                              | EXTENDED_STORED_PROCEDURE        |
| sp_publish_database_to_syms                                | EXTENDED_STORED_PROCEDURE        |
| sp_query_store_clear_hints                                 | EXTENDED_STORED_PROCEDURE        |
| sp_query_store_clear_message_queues                        | EXTENDED_STORED_PROCEDURE        |
| sp_query_store_set_hints                                   | EXTENDED_STORED_PROCEDURE        |
| sp_release_all_fido_locks                                  | EXTENDED_STORED_PROCEDURE        |
| sp_release_fido_lock                                       | EXTENDED_STORED_PROCEDURE        |
| sp_reset_inactive_duration_flag                            | EXTENDED_STORED_PROCEDURE        |
| sp_reset_msdtc_log                                         | EXTENDED_STORED_PROCEDURE        |
| sp_set_data_processed_limit                                | EXTENDED_STORED_PROCEDURE        |
| sp_set_database_engine_configuration_internal              | EXTENDED_STORED_PROCEDURE        |
| sp_set_def_format_type_default_target                      | EXTENDED_STORED_PROCEDURE        |
| sp_set_def_format_type_extractor                           | EXTENDED_STORED_PROCEDURE        |
| sp_set_def_format_type_md_preprocessor                     | EXTENDED_STORED_PROCEDURE        |
| sp_set_distributed_feedback_context                        | EXTENDED_STORED_PROCEDURE        |
| sp_set_format_type_ls_syntax                               | EXTENDED_STORED_PROCEDURE        |
| sp_set_msdtc_network                                       | EXTENDED_STORED_PROCEDURE        |
| sp_set_parser_version_default_target                       | EXTENDED_STORED_PROCEDURE        |
| sp_set_parser_version_extractor                            | EXTENDED_STORED_PROCEDURE        |
| sp_set_parser_version_md_preprocessor                      | EXTENDED_STORED_PROCEDURE        |
| sp_set_trident_data_location                               | SQL_STORED_PROCEDURE             |
| sp_show_external_table_average_column_length_statistics    | EXTENDED_STORED_PROCEDURE        |
| sp_show_openrowset_statistics                              | EXTENDED_STORED_PROCEDURE        |
| sp_shutdown_feedback_client_connection                     | EXTENDED_STORED_PROCEDURE        |
| sp_start_fixed_vlf                                         | EXTENDED_STORED_PROCEDURE        |
| sp_start_flight_server                                     | EXTENDED_STORED_PROCEDURE        |
| sp_start_glm_server                                        | EXTENDED_STORED_PROCEDURE        |
| sp_start_streaming_job                                     | SQL_STORED_PROCEDURE             |
| sp_stop_flight_server                                      | EXTENDED_STORED_PROCEDURE        |
| sp_stop_streaming_job                                      | SQL_STORED_PROCEDURE             |
| sp_update_logical_pause_deactivation_params                | EXTENDED_STORED_PROCEDURE        |
| sp_update_logical_pause_flag                               | EXTENDED_STORED_PROCEDURE        |
| sp_update_streaming_job                                    | SQL_STORED_PROCEDURE             |
| sp_upgrade_vdw_configuration_parameters                    | EXTENDED_STORED_PROCEDURE        |
| sp_verify_database_ledger                                  | EXTENDED_STORED_PROCEDURE        |
| sp_verify_database_ledger_from_digest_storage              | EXTENDED_STORED_PROCEDURE        |
| sp_xcs_mark_column_relation                                | EXTENDED_STORED_PROCEDURE        |
| sql_pools_table                                            | INTERNAL_TABLE                   |
+------------------------------------------------------------+----------------------------------+

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.