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. 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’ve read the list, a few events caught my attention.
Indicates that a cancel operation, client-interrupt request, or broken client connection was received, triggering abort.
I can upgrade the
result = 2 (abort) and use this event instead.
It also shows the
KILL statements from other sessions.
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.
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
But I think it has potential.
Anyway, which event do you think will be useful? Let me know!