Am I missing anything obvious while tuning this query ?

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.

avatar image By sqlzees 1 asked Jan 12, 2016 at 09:28 PM
more ▼
(comments are locked)
avatar image Matak Jan 12, 2016 at 11:29 PM

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.

avatar image sqlzees Jan 13, 2016 at 02:08 PM

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. "

avatar image Matak Jan 13, 2016 at 10:42 PM

Did you copy all of the sql code into plan explorer and then click "Get Actual Plan" ?

avatar image sqlzees Jan 15, 2016 at 01:19 PM

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.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x166
x89
x44
x27

asked: Jan 12, 2016 at 09:28 PM

Seen: 376 times

Last Updated: Jan 15, 2016 at 01:19 PM