Fast query runs really poorly on VM Server

I have tried tweaking the MDOP and threshold to no effect. Closer examination of queries, indicate estimates are off despite rebuilding indices. Can see spillovers in actual plan. This is an SQL generated by the SSAS processor, so I cannot change it. I have experimented with indices but to no avail.

avatar image By jlj 0 asked Apr 19 at 04:15 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x554
x372
x14
x2
x1

asked: 6 days ago

Seen: 31 times

Last Updated: 6 days ago