My SQL Server 2016 had been presenting problems certain days, all process since the morning begins to run slowly than normally. Sometimes updating statistics works, sometimes not and had to reboot service. In query plan, when things go wrong with the "main" query, it shows a high negative value, after things start to work well, the query plan show normal values.

statistics with problem

after all

There is something else thing I could do and somebody knows why sometimes update stats doesn't work?

Thanks in advance

  • Can you share the execution plan, view, and table definitions? Mar 8, 2018 at 19:40
  • Has this problem started after migrating to 2016 ?Some time poorly written query which involve lot of data, work inconsistently.Like when cache get full then cardianlity estimation goes wrong ?May you should check compatiblity level of 2016
    – KumarHarsh
    Mar 9, 2018 at 11:53
  • Yes, I started to view this behavior after migration to 2016. I switched the compatibility level to 130. You have reason involving a poorly query. I'm going to report that to developer team and leave database level on 100 again. I'll let you know what happen after all. Thank you Mar 9, 2018 at 13:14
  • Any updates ? When you switched the compatibility level to 130 then what happened ?
    – KumarHarsh
    Apr 19, 2018 at 5:45
  • Hello @KumarHarsh, After change it again to compatibility level 100 it had been working well. Thankyou so much Apr 30, 2018 at 19:19


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.