Tagged Questions
4
votes
3answers
411 views
Dealing with CXPACKET waits - setting cost threshold for parallelism
As a follow-up to my previous question on perf troubleshooting a Sharepoint site, I was wondering if I could do something about the CXPACKET waits.
I know the knee-jerk solution is to turn off all ...
3
votes
2answers
272 views
Parallel Statistics Update
In SQL Server 2008 or later, is UPDATE STATISTICS WITH FULLSCAN a single threaded operation or it can use parallelism? How about update statistics with default sampling - can it use parallelism? I ...
4
votes
4answers
3k views
CXPACKET Waits performance tune for SQL Server 2008
I have a SQL Server 2008 query that is working on millions of records. The query is w/in a proc that is run nightly by a job. The query can take a full day to run when I first put it on the server, ...
3
votes
1answer
509 views
Query Parallelism
I have a long running query that behaves differently between two different machines.
I have an 8 core machine running Microsoft SQL Server Developer Edition (64-bit) that does not use parallelism and ...
3
votes
2answers
476 views
A query submitted from different applications has differing DOP
I have a query which selects from multiple views and is fairly I/O heavy. If I execute this query using Management Studio it uses parallelism across most of the 16 CPUs and completes in under 10 ...
