SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is not quite ready yet.
Anyway, because I'm a #TeamXE, I had to check out if there are any new goodies there. Extended Events are how I investigate errors, so a new SQL Server version is Christmas morning. So, I took an XE event list from Microsoft SQL Server 2019 (RTM-CU16) and the new one from Microsoft SQL Server 2022 (CTP2.0) and compared them.
The list
There are precisely 500 new events between those two versions.
As you would expect, a big chunk of them relates to the new or improved stuff SQL 2022 is bringing.
Like the Parameter Sensitive Plan (PSP) optimization, Cardinality Estimator Feedback and others.
To check the complete list yourself, you can import it into a temp table from this gist - New Extended Events in SQL Server 2022.
Interesting events
After I read the list, a few events caught my attention.
query_abort
Indicates that a cancel operation, client-interrupt request, or broken client connection was received, triggering abort.
I can replace my old rpc_completed where result = 2 (abort) trick with this event instead.
It also shows the KILL statements from other sessions.
tsql_feature_usage_tracking
Track usage of t-sql features in queries for the database
The event returns a column features_used - Provides a bitmap of features used in query.
I couldn't get this event to fire, and even if I did, I probably couldn't parse the bitmap without documentation.
query_antipattern
Occurs when a a query antipattern is present and can potentially affect performance.
(The quote is verbatim, so I left the typo in there).
So far it only identifies these antipatterns:
- TypeConvertPreventingSeek
- NonOptimalOrLogic
- LargeIn
- LargeNumberOfOrInPredicate
- Max
But I think it has potential.
Anyway, which event do you think will be useful? Let me know!
Thank you for reading