August 9, 2012 at 12:04 am
Comments posted to this topic are about the item SQL Server 2012’s Information on Parallel Thread Usage
August 9, 2012 at 12:56 pm
I usually struggle w/ improving queries involving parallelism. Some dbas I've worked with recommended MAXDOP hint.
Even with those recommendations, I notice my queries some time don't use all available CPUs. I'd see it did the work with 8 CPU out of 24+ available to it. Is that necessarily a good thing? Sorry I hope I haven't deviated too much from your topic.
August 9, 2012 at 3:27 pm
Hi Rajib,
In my example - I had 8 schedulers available but the 24 represents the threads reserved for the execution of the query (lifetime of the query).
Regarding queries sometimes not using all available CPUs, there are a few different areas to examine or consider.
The costing uses half of the available schedulers as an assumption. For example, in my article the costing was based on 4 but executed with 8. Feel free to share your specifics here and we can discuss further.
Cheers,
Joe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply