Share via

SSMS Object Explorer unresponsive

Kewlri 0 Reputation points
2023-11-23T12:53:57.5033333+00:00

Anytime I try to right click, expand my database folder, or making a diagram in Object Explorer, the right click context menu takes 13-20 seconds to appear, the whole SSMS even went Not Responding at times.

I personally don't think my laptop would be that bad for SQL in general (Intel Core i7-12700H, 2x8GB DDR5 4800MHz, 1TB NVMe Gen 4 SSD)

Trying the same database on friend's laptop (Intel Core i5 1135G7, 8GB DDR4, 256GB NVMe Gen 3 SSD) and the Object Explorer did not take that long to respond to interactions.

(both laptops using SQL Server 16.0.1000, SSMS 19.2)

What can I do to make Object Explorer more responsive ?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-11-24T02:45:47.9+00:00

    Hi @Kewlri

    Since there is no error, there is little documentation on this.

    You can refer to this document. Hope it can help you.

    https://forum.red-gate.com/discussion/85708/ssms-object-explorer-right-click-menu-very-slow

    Best regards,

    Percy Tang

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.