What to Target First

ToddHisted 2014-12-01 17:11:03

I removed some of the sorts which Plan Explorer was originally flagging as the cause. This stored proc is running in about 16 seconds, but needs to be around 2 seconds or less.

Farhaj Ahmed Khan 2015-01-09 07:34:50
Can you check after rebuilding the indexes.
@SQLTrooper 2014-12-01 17:40:47
At first glance, you have some Key Lookups you should be able to get rid of (included columns on existing indexes). I would start there – often times that can drastically improve performance.
SQLkiwi 2014-12-03 08:21:32
I would look to eliminate the Eager Index Spools. Check the seek predicates and provide permanent indexes where possible.