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

Dominic Legendre 36 Reputation points
2022-04-29T19:33:43.353+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,676 questions
Accepted answer
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2022-05-02T03:15:38.747+00:00

    Hi @Dominic Legendre ,

    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".

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.9K Reputation points MVP
    2022-04-29T21:13:00.193+00:00

    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

    0 comments