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

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