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.
By jlj 0 asked Apr 19 at 04:15 PM