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, 2017 at 04:15 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Apr 26, 2017 at 04:28 PM

You have a seek that returns 61 million rows. That seems to be a very odd choice for the optimizer to make, and you can see that it expected 30 rows there, not 61 million - is it possible this query was compiled when the data looked very different? Have you tried explicitly updating statistics? Have you tried adding OPTION (RECOMPILE) to the query just as a test to see if the optimizer makes a better decision when forced to look again?

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



asked: Apr 19, 2017 at 04:15 PM

Seen: 161 times

Last Updated: Apr 26, 2017 at 04:28 PM