AWS re:Postを使用することにより、以下に同意したことになります AWS re:Post 利用規約
AWS re:Postre:Post

Some SSMS operations are very slow

0

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!

トピック
データベース移行と近代化分析
タグ
マイクロソフト SQL サーバーAmazon Relational Database Service (RDS)
言語
English
TedF
質問済み 2年前1868ビュー
1回答
0
承認された回答

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

I hope this helps.

Lunga T
回答済み 2年前
  • TedF
    2年前

    Thank you! My problem does not involve SSMS startup, but these issues may be at play.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ