This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
Today we are excited to announce that the Degree of Parallelism (DOP) Feedback feature is available for a limited preview in Azure SQL Database. DOP Feedback was released with SQL Server 2022 and is now available for trial on SQL DB. For more information, see Query processing feedback features.
Who should try DOP Feedback?
If your server is running with parallelism (Max DOP of 0 or Max DOP greater than 2), you may be a candidate to try this feature. You also need to be running repeated queries that are long-running and captured in query store. One of the best ways to understand if your workload would be a good candidate for the trial is to run the following query:
If you have multiple heavy-hitter queries (running 10 seconds or more) in this list with a degree of parallelism 4 or above, you may consider trying this feature.
What are the benefits?
Degree of parallelism feedback could benefit your workload by reducing overall CPU time, overall parallelism waits, and overall query times. You would also be helping the team ship this feature and would have an opportunity to work 1:1 with the team during preview.
What are the risks?
At this time, DOP Feedback is considered a preview feature. This means that we might have unexposed bugs that could impact your workload. Since the feature suggests lower degree of parallelism values for the queries to run with, you may encounter some degradation in the query performance if the feedback validation is not accurately done. Should you encounter any issues with the product, we would request that you reach out to our team for assistance as appropriate.
I’m sold, where do I sign up?
Just fill out this form, and if the team feels you are a good candidate for the feature, we will be in touch.