question

DominicLegendre-1992 avatar image
0 Votes"
DominicLegendre-1992 asked Cathyji-msft commented

SSMS 18.1.11 extremely slow to close or hangs and must be killed

I connect to many computers throughout the week using Teamviewer VPN. I can connect very easily, the problem is if I lose connection or forget to close SSMS first, it's stuck for an extremely long time with a querying selection count and finally gives an error unable to determine if there are open transactions.

This happens for every open query tab one at a time and can take over 15 minutes to close SSMS. If I don't forget to close the studio first while the VPN connection is still connected, it chimes a Windows sound in the background and still takes a very long time to close SSMS.

This is super annoying and need immediate resolution. I can't find any settings to stop this from happening.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image Cathyji-msft ·

Hi @DominicLegendre-1992,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If you have further question, please feel free to let us know.

0 Votes 0 ·

2 Answers

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

The best I can do is point you to this feedback item where you can cast your vote:
https://feedback.azure.com/d365community/idea/aaaad978-65b9-ec11-a81c-6045bd80aaa9



5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @DominicLegendre-1992,

Erin Stellato mentioned in this feedback ;

We have logged this issue internally and are planning to address this in the next release.

You can temporarily use the previous version of SSMS and waiting for next new version released.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".



5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.