Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-05-15 : 16:28:26
|
| Gurus, I'm failry new with sql 2005 and have been experiencing an issue with some complex queries. Lately, anything more complex than the usual select from (an update on large table for instance), appears on the activity monitor as 8 different processes (8 = number of logical processors), the task never ends and these processes are marked as wait_type = CXPACKET.I was doing some reading, and apparently I need to decrease the number of parallel threads (Am I right?), but I'm unsure how to do so.I believe we're not be making use of pararllelism and partitioning as we should.Let me know if you guys can think of anything to help.---"Try not to become a man of success but rather try to become a man of value." |
|
|
|
|
|
Parallelism and CXPACKET waits