Performance Issues

ny sugestions to improve peroformance ?

Thanks

Plan.pesession (1.1 MB)
avatar image By inginheiiro 1 asked May 08, 2017 at 10:42 AM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ May 08, 2017 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, 2017 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:

x676
x489
x124
x115
x20

asked: May 08, 2017 at 10:42 AM

Seen: 92 times

Last Updated: May 09, 2017 at 07:25 AM

Related Questions

How can I improve this stored performance?

Any ideas to increase performance of this query?

Same Query, Two Plans, One Stinks

Component running slow

Is there a better way to search for matches

Execution plan mystery

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

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

Stored procedure randomly using bad execution plan

A filter with the attached query causing slowness and performance issues