Slow response on webpage
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.
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.
2015-01-09 12:52:06
There are many thing which can slow the response on webpage. You didn't mentioned the completed detail.
Regards,
Farhaj Ahmed Khan