1

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 '16 at 12:53
  • I checked again and it's latest SSMS 2016. – Ashwini Mohan Sep 19 '16 at 12:59
  • UserFeedbackOptIn is 1. Will it impact in anyway? – Ashwini Mohan Sep 19 '16 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 '16 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 '16 at 14:35
0

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, privacy policy and cookie policy

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