SQL Server 2012’s Information on Parallel Thread Usage

  • Joe Sack SQLskills

    Old Hand

    Points: 314

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

  • Rajib Bahar

    SSC Eights!

    Points: 957

    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.

  • joe.sack

    SSC Rookie

    Points: 30

    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 3 (of 3 total)

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