Performance Issues

ny sugestions to improve peroformance ?

Thanks

Plan.pesession (1.5 MB)
avatar image By inginheiiro 1 asked May 08 at 10:42 AM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ May 08 at 06:33 PM

There are some things here that I'm not sure you can make better - parsing JSON, for example, there is no magic in SQL Server 2014. I would start by getting rid of the table variables. For better input, please generate an actual plan from within Plan Explorer - this will add runtime metrics and other data you don't get when you open a plan generated in Management Studio (especially an estimated plan).

10|10000 characters needed characters left
▼ Viewable by all users
0
1 answer: sort voted first ▼

Hi,

thanks for the feedback.

i've attached the plan (XML)

link text

plan.xml (167.1 kB)
avatar image By inginheiiro 1 answered May 09 at 07:25 AM
more ▼
(comments are locked)
10|10000 characters needed characters left
▼ Viewable by all users
0
Your answer
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:

x588
x405
x107
x105
x20

asked: May 08 at 10:42 AM

Seen: 53 times

Last Updated: May 09 at 07:25 AM

Related Questions

How can I improve this stored performance?

Same Query, Two Plans, One Stinks

Is there a better way to search for matches

Component running slow

Execution plan mystery

How can I improve this plan. Table Insert is costing the most at 84.6% - can it be improved ?

Any idea why the filter limiting to 5K instead of 320K rows is done at the end ?

Stored procedure randomly using bad execution plan

A filter with the attached query causing slowness and performance issues

Trying to understand why partition elimination is happening in some plans, but not others