One issue that can cause this problem is that if the server does not have access to the internet, then the. Reference: FAQ, Why does SSMS take 45s to start up? (MSDN Blog) If there is no internet connection or there is a problem contacting the certificate revocation list server then this will delay SSMS startup. Net Runtime tries to contact to ensure that the cert is valid(there were some fake certs issued in Microsoft’s name a while back so this is a very valid concern). At start up (if this setting is checked) the. SSMS has a high percentage of managed code, all of this code is signed when we ship it. This slows down the overall loading procedure. NET components of SSMS are trying to contact the Certificate Revocation List and SSMS is unable to do so. When Microsoft's SQL Server Management Studio (SSMS) starts it tries to connect the Certificate Revocation List (CRL) of Microsoft:
#Ms sql studio 2016 install#
I don't have the opportunity to install the SQL Server 2012 CU1 update because there seems to be some risk of errors installing hotfixes and I can't risk that right now. It looks like SSMS is waiting for something - I can operate other programs smoothly while this is happening. My hardware should definitely not be a problem. My computer should be more than fast enough, and I also have 16GB RAM.
Updating video drivers, turning off hardware acceleration, disabling DirectX.A hit on Google where I'd need to modify my hosts file.
Other applications establish connections to the database very fast. Why does this happen and how can I fix it? This happens every time, even if I open the same window twice in a row. There is typically at least a 5 second delay before I can start doing anything within a window. After upgrading both SQL Server and Management Studio from 2008 to 2012, Management Studio 2012 is very slow when new query windows and dialog boxes are opened.Įven right clicking on tables is slow.
0 kommentar(er)
