Performance Issues

inginheiiro 2017-05-08 10:42:43

ny sugestions to improve peroformance ?

Thanks

Aaron Bertrand 2017-05-08 18:33:22
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).
inginheiiro 2017-05-09 07:25:21
Hi,

thanks for the feedback.

i've attached the plan (XML)

link text