I am connecting to a database server(MSSQL 2008R2) using SSMS 2016 and for simple queries even like "USE DBNAME", it's taking 4-5 secs. However time stat shows "CPU time = 0 ms, elapsed time = 0 ms", not sure why?

On the other hand, If I connect the same server using SSMS 2008R2, it gets executed instantly.

I compared client statistics for both SSMS2008R2 AND 2016 but both shows almost same stats.

Why my SSMS2016 is behaving like this?

  • Are you using the latest SSMS 2016 ? Also, what is the value of UserFeedbackOptIn 1 or 0 ?
    – Kin Shah
    Sep 19, 2016 at 12:53
  • I checked again and it's latest SSMS 2016. Sep 19, 2016 at 12:59
  • UserFeedbackOptIn is 1. Will it impact in anyway? Sep 19, 2016 at 13:00
  • 2
    I have changed it for SSMS 2016 .. look for HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\13.0\UserFeedbackOptIn
    – Kin Shah
    Sep 19, 2016 at 13:04
  • 1
    You did not mention that you had Apex Addin .. that would be my first choice to disable. Glad that it helped.
    – Kin Shah
    Sep 19, 2016 at 14:35

1 Answer 1


Changing the below setting and uninstalling some add ons for SSMS 2016 helped me -

HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\13.0\UserFeedbackOptIn

Thanks @Kin.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.