Activity overview
Latest activity by mcook
@Jon_Kirkwood yes, this primarily affects databases that I'm connecting to over a P2P VPN network. Databases that are within the local network still take a few seconds to refresh the SQL Prompt suggestions, but not as long as databases that reside in another data center. All of our databases are local, we do not have any Azure databases that we are connecting to. I have reviewed the document you provided and have already done most of the suggestions there. However, the slowness is directly related to SQL Prompt, it's not general slowness. This was not happening with previous versions, so it seems that rolling back to a previous version sounds like the best remedy unless there is a way to disable the additional database scans that are taking place. / comments
@Jon_Kirkwood yes, this primarily affects databases that I'm connecting to over a P2P VPN network. Databases that are within the local network still take a few seconds to refresh the SQL Prompt sug...
SQL Prompt taking a long time to refresh suggestions
Recently, SQL Prompt has been taking a very long time (10+ seconds) to refresh the suggestions. It seems to primarily be happening with a new SSMS instance, but also happens when switching catalogs...
I'm having the same issues after upgrading to SSMS 20.1. Didn't happen with SSMS 19. Suuuuuper annoying. Can confirm that disconnecting from the server works. / comments
I'm having the same issues after upgrading to SSMS 20.1. Didn't happen with SSMS 19. Suuuuuper annoying. Can confirm that disconnecting from the server works.