New Extended Events Stuff In SQL Server 2022

I am a heading


Some events:

event_name
memory_grant_feedback_percentile_grant
memory_grant_feedback_persistence_update
parameter_sensitive_plan_optimization
process_killed
query_optimizer_nullable_scalar_agg_iv_update
spinlock_backoff
sql_exit_invoked
tsql_feature_usage_tracking

A bunch of stuff:

package_name event_name description
qds automatic_tuning_query_check_ignored Fired when APRC decides to not track a query that is marked as ignored
qds automatic_tuning_wtest_details

New Query Transformation Rules In SQL Server 2022

Brand New


Here are new lines from the query transformation stats view in SQL Server 2022:

+--------------------------------+
|              name              |
+--------------------------------+
| BuildDataExportPut             |
| BuildRemotePut                 |
| EnforceDistribution            |
| FetchXcs                       |
| GetToFetchXcs                  |
| ImplementDistribution          |
| 

New System Configurations In SQL Server 2022

Brand New


Here are new sys.configuration entries in SQL Server 2022:

+------------------------------------+-------------------------------------------------------------------------------------+
|                name                |                                     description                                     |
+------------------------------------+-------------------------------------------------------------------------------------+
| Data processed daily limit in TB   | SQL On-demand data processed daily limit in TB                                      |
| Data processed weekly limit 

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                         |
| 

New System Object Columns In SQL Server 2022

Brand New


Here’s a list of new system object columns in SQL Server 2022!

+----------------------------------------+------------------------------------------------+
|              object_name               |                  column_name                   |
+----------------------------------------+------------------------------------------------+
| all_columns                            | is_data_deletion_filter_column                 |
| all_columns                            | is_dropped_ledger_column                       |
| all_columns                            | ledger_view_column_type                        |
| all_columns                            | ledger_view_column_type_desc