March 24, 2023 at 12:00 am
Comments posted to this topic are about the item Adjusting DOP based on Feedback
March 24, 2023 at 11:26 am
Not sure that answer is correct. From what I've read (e.g. https://cloudblogs.microsoft.com/sqlserver/2022/10/20/intelligent-query-processing-degree-of-parallelism-feedback/), DOP is adjusted down until performance was better at the previous level, at which point it is adjusted back up to that previous level. It never increases DOP beyond the original setting, but it does adjust it down and up to optimize the query. None of the answers are great, but the best answer is:
It adjusts DOP up or down from the settings to minimize query time
It's definitely not "adjusts DOP down from the settings to minimize parallelism" - minimising parallelism would just be setting DOP to 2.
March 26, 2023 at 6:57 pm
I completely agree. As the question is written, the correct answer based on the documentation provided is that it can be adjusted both up and down. Per the documentation, adjusting up or down is based on specific conditions. If the question included specific conditions necessary for adjusting down, then the correct answer would be only adjusting down.
March 27, 2023 at 3:12 pm
Adjusted the wording. The aim is to minimize parallelism for any query. Not to set the minimal parallelism, but minimize the number of cores being used, as this can be more efficient for a workload, not a query.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply