SQL Server 2022: Accelerate query performance while reducing query compile time - w/ no code changes

Learn more about the plan compilation features contained within SQL’s Intelligent Query Processing offering, how they work, what common scenarios benefit from them, and how to get the most from them.

00:20 - Introduction
00:44 - Optimized Plan Forcing explained
02: 45 - Phases
03:30 - Demo
07:40 - How to take advantage of this feature
11:05 - Cautions
12:15 - Closing

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer

[gandharjayantaundhe]

Great! Thank you so much for the update!voila show! Greatness nurtured!

[FerriGT]

Waiting for Brent Ozar comments on this new feature ;-)

[danielegiovanetti]

Is it valid for Azure sql too? Is there other way for tuning query in Azure? Very interesting topic. Thanks for sharing

[hankiwi]

The demo looks really nice but doesn't really work, I think. The high compile time you get at first execution is most likely statistics related (update + no stats on the modifieddate column). This is evidenced by disabling the auto update/create stats, or worse, by reexecuting the query after emptying the plan cache, without using the optimized plan forcing feature. The compile time will then be drastically reduced, making the query unelligible for plan replay. You need a more complicated query for that demo. Having more info on the compile time threshold would be nice.