Some SSMS operations are very slow

Question

When I connect to my RDS SQL Server instance through SSMS, queries execute nicely from a query window. But any operation that uses SSMS features to retrieve metadata takes very long, several minutes! For example, activating the drop-down list of databases on the instance, or retrieving the properties of a table, or even retrieving a list of tables on a database. Can someone explain why this happens?

Thanks!

Accepted Answer

Hello TedF,

I did some research on this issue and I found out that the slowness of SSMS is actually caused by the underlying .NET components of SSMS (when SSMS starts), which are trying to contact the Certificate Revocation List and SSMS is unable to do so. This slows down the overall loading procedure.

Refer to this [MS FAQ](https://docs.microsoft.com/en-us/archive/blogs/euanga/faq-why-does-ssms-take-45s-to-start-up)  which provides guidance to resolve the issue, and to find out why SSMS takes 45s to startup?

To find a more detailed explanation about the slowness of SSMS, refer to this [MS Doc](https://docs.microsoft.com/en-us/archive/blogs/dtjones/sql-server-management-studio-startup-time).

I hope this helps.

Some SSMS operations are very slow

Contenuto pertinente