Tag: Parallelism
Parallelism: Stop waiting!
In my previous blog post ‘Parallelism: Hurry up and wait’ I discussed how parallel queries cause CXPACKET waits. I also covered the common causes for these waits to be high on an OLTP server. Today I want to finish up my thoughts on the subject and hopefully round out the discussion for both OLTP and [...]
Posted: January 25th, 2011 under Wait Stats.
Tags: cost threshold for parallelism, CXPACKET, Parallelism, Query Optimization, Query Performance, Query Tuning, SQL Doctor, SQL Server 2005, SQL Server 2008, SQL Server Performance, Wait Stats
Comments: none
Parallelism: Hurry up and wait
At the 2010 SQL PASS Summit we had the great pleasure of speaking with the well known SQL Server MVP Pinal Dave (blog). One of the topics that were discussed was the use of wait stats by SQL doctor for generating recommendations and he agreed to spend extra time with us to discuss his [...]
Posted: January 14th, 2011 under Wait Stats.
Tags: cost threshold for parallelism, CXPACKET, max degree of parallelism, Parallelism, Query Optimization, Query Performance, Query Tuning, SQL Doctor, SQL Server 2005, SQL Server 2008, SQL Server Performance, Wait Stats
Comments: 2
