Am I missing anything obvious while tuning this query ?

sqlzees 2016-01-12 21:28:55

I have this SQL query which runs against multiple databases. There were originally no indexes and I created some, after creating them it is doing Index seek but that is not helping very much. Original run time was 3:05 minutes now it runs in about 2:35. Please take a look at the plan and point out any areas that need attention.

Matak 2016-01-12 23:29:39
Can you put up a plan that has been run from Plan Explorer ?
This one looks to have been run from Management Studio and reopened in Plan Explorer.
Its missing information that will probably be useful.

Also, your functions are most likely killing the performance. They may show up as very small costs but thats not necessarily the case.

sqlzees 2016-01-13 14:08:36
When I tried executing the query from Plan Explorer, I got a message that read:

"A query plan was not collected at the time of execution. Estimated plan generation is only available for non-dynamic root statements on SQL server 2005 and higher. "

Matak 2016-01-13 22:42:09
Did you copy all of the sql code into plan explorer and then click "Get Actual Plan" ?
sqlzees 2016-01-15 13:19:00
I did, it runs the query and after the query runs shows this message. Without the plan or diagram, but only with the tables of stats that has a breakdown of query cost.