New answers tagged

0

If you want to run in parallel you have to design for it. Things to consider is using partitions so they can be scanned in parallel. Don't forget that parallelism in general will try to use full scans on segments. Partition pruning can help reducing the size of your scans. If you really are using pq for this sort of small queries, make sure you have enough ...


0

as Remus says you have a performance problem, probably because of mixed workload and poorly tuned sql statement. In my experience the best way to solve is to use a performance/tuning approach on sql queries. If this is not possible or if you have to manage a critical situation you can lower the highest value limit for the MAXDOP parameter. To find a better ...


0

majority OLTP type workload with some OLAP mixed in This is the problem, not the CXPACKET. Parallelism is a symptom, not a cause. Your 'some' OLAP workload is doing scans which trigger parallelism, which cascades into exchange wait times, likely buffer pool pollution and possible blocking (OLTP workload blocks behind OLAP scans). If the OLAP workload ...



Top 50 recent answers are included