how do i improve the performance?

Mathuzalem de Melo 2015-06-24 11:51:22

Aaron Bertrand 2015-06-25 15:43:04
With an anonymized plan not generated from within Plan Explorer, it is hard to say with any certainty where the performance problem really is, never mind how to address it. Can you please update to the latest version (see here for why, generate an actual plan from within Plan Explorer, and then upload that anonymized plan (or non-anonymized if possible).