Sample Header Ad - 728x90

SQL Server Management Studio (SSMS) is way too slow in its GUI

5 votes
5 answers
20236 views
I know this question has been asked before here and here . But none of them could solve my problem. I have this environment: 1. Windows 10, build 1903 (freshly installed) 2. Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 18362: ) 3. SSMS v17.3 (14.0.17199.0) Any activity I want to do in it, from opening, to connecting to a database engine, to right-clicking on a database, to creating a new database, to opening up a new query window, to browsing tables, any activity that is not query takes like 5 to 10 seconds to perform. It's clearly apparent that SSMS is doing something for each activity, and it gets stuck somewhere. Here are the things I've done so far, without effect: 1. Blocked Microsoft's certificate URL (adding 127.0.0.1 crl.microsoft.com to hosts file) 2. Downloading certificate and installing it from http://crl.microsoft.com/pki/crl/products/MicrosoftRootAuthority.crl 3. Connecting to "local" instead of "." 4. Resetting user-defined settings in "C:\Users\user\AppData\Roaming\Microsoft\SQL Server Management Studio" 5. No antivirus is installed (only Windows Defender, the default of Windows) It's a shame that a program from such a reputable company can't work smooth out of the box, and troubleshooting it is very difficult. How can I diagnose what's wrong with SSMS? Update: This problem exists even with SSMS v18.2 (15.0.18142.0)
Asked by Saeed Neamati (1515 rep)
Sep 21, 2019, 10:16 AM
Last activity: Jul 16, 2025, 09:36 AM