SQL Server 2012’s Information on Parallel Thread Usage

  • Comments posted to this topic are about the item SQL Server 2012’s Information on Parallel Thread Usage

  • 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.

  • 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.



Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply