HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
ssmsserversqlwaytooslowitsstudiomanagementgui

Problem

I know this question has been asked before here and here. But none of them could solve my problem. I have this environment:

  • Windows 10, build 1903 (freshly installed)



  • 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: )



  • 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:

  • Blocked Microsoft's certificate URL (adding 127.0.0.1 crl.microsoft.com to hosts file)



  • Downloading certificate and installing it from http://crl.microsoft.com/pki/crl/products/MicrosoftRootAuthority.crl



  • Connecting to "local" instead of "."



  • Resetting user-defined settings in "C:\Users\user\AppData\Roaming\Microsoft\SQL Server Management Studio"



  • 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)

Solution

I also had the mystery slow down in v14 and then upgraded to 18.5 Post upgrade 18.5 worked fast...a few days (and reboots) later it bogged down again. Network trace showed a ton of IP6 traffic which we have not configured but somehow became a default 'on' in Windows 10.

Disabled Ip6 on the ethernet adapter and all working fine now.

Context

StackExchange Database Administrators Q#249339, answer score: 4

Revisions (0)

No revisions yet.