October 26, 2010 at 4:48 pm
I have 3 queries which basically the same but hitting different DBs. One of the query do not using parallism and it is take hours to load 15m rows compared to another that takes 1 hr to load 150m rows.
I know the optimizer decide when to use parallelism. What can i change to affect the optimizer other than changing the query.
MAXDOP option does not have any effect.
October 26, 2010 at 11:17 pm
merlin2864 (10/26/2010)
I have 3 queries which basically the same but hitting different DBs. One of the query do not using parallism and it is take hours to load 15m rows compared to another that takes 1 hr to load 150m rows.I know the optimizer decide when to use parallelism. What can i change to affect the optimizer other than changing the query.
MAXDOP option does not have any effect.
try this
http://www.sql-server-performance.com/faq/query_parellelism_cpu_p1.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/04/17/parallel-query-execution-presentation.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply