Slow response on webpage

Klas Uppling 2014-01-31 14:32:04

SQLkiwi 2014-01-31 14:43:40
Please upload a plan with post-execution information (an 'actual' plan) – ideally one captured using Plan Explorer directly, not copied from SSMS. We need to see runtime information to diagnose a performance problem accurately. If you're happy with a guess, I'd say the sort ends up processing much more than 1 row, and the operation spills to disk.
Dan Holmes 2014-01-31 14:44:29
There just isn't enough information in the narrative or the plan for me to make any kind of recommendation. The plan is an estimate only and anonymized. The title says 'slow response on webpage' and i have to presume that this statement is the culprit. Just not enough information to help.
Farhaj Ahmed Khan 2015-01-09 12:52:06
There are many thing which can slow the response on webpage. You didn't mentioned the completed detail.

Farhaj Ahmed Khan