Aug 29 2024 03:53 PM
I connect to one Azure SQL database hosted on "site".database.windows.net. Ever since installing SSMS 19 and continuing with 20 I have a problem where the database connection seems to timeout or drop. When this happens SSMS hangs for 5 minutes. It happens after I open an Edit connection and let it idle View connections don't cause the problem. I can go back to 18 and the problem doesn't happen. It seems like the connection drops and then takes 300 seconds to timeout and retry. Then it works again until it idles again. It is super frustrating.