sql-server – SQL Server Management Studio慢速打开新窗口

从2008年到2012年进级SQL Server和Management Studio后,在打开新的查询窗口和对话框时,Management Studio 2012很是慢.

纵然右键单击表格也很慢.在我开始在窗口内做任何工作之前,凡是至少有5秒的耽误.每次城市产生这种环境,纵然我持续两次打开统一个窗口.为什么会产生这种环境,我该怎样办理？

其他应用措施很是快地成立与数据库的毗连.

我试过的工作没有辅佐：

>点击谷歌,我必要修改我的主机文件
>重置SSMS“用户界说的配置”
>更新视频驱动措施,封锁硬件加快,禁用DirectX
>禁用生物辨认身份验证处事(我没有安装它).

我的电脑应该足够快,我也有16GB的RAM.我的硬件必定不是题目.看起来SSMS正在守候某些工作 – 我可以在这种环境下顺遂运行其他措施.

我没有机遇安装SQL Server 2012 CU1更新,由于安装修补措施好像有一些错误的风险,我此刻不能冒这个风险.

办理要领

当Microsoft的SQL Server Management Studio(SSMS)启动时,它会实行毗连Microsoft的证书吊销列表(CRL)：

http://crl.microsoft.com/pki/crl/products/MicrosoftRootAuthority.crl

SSMS的基本.NET组件正在实行接洽证书吊销列表,SSMS无法执行此操纵.这会减慢整个装载进程. (显然每张证书15秒)

Ok so here is what is happening. SSMS has a high percentage of managed code,all of this code is signed when we ship it. At start up (if this setting is checked) the .Net Runtime tries to contact crl.microsoft.com 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). If there is no internet connection or there is a problem contacting the certificate revocation list server then this will delay SSMS startup.

参考：FAQ,Why does SSMS take 45s to start up? (MSDN Blog)

One issue that can cause this problem is that if the server does not have access to the internet,then the .NET framework can’t access the crl.microsoft.com website to verify that the digital signatures used to sign the binaries for managed applications are valid. Each certificate check has a 15 second timeout in the .NET runtime implementation. Depending on what features are installed,this can add up to a minute of startup time for Management Studio.

参考：SQL Server Management Studio Startup Time (MSDN Blog)

办理方案

您可以通过直接下载证书进入赏识器的链接,然后将证书导入证书数据库来规避部门题目

>或 –

您可以从头设置(公司的)防火墙以应承毗连到Microsoft的CRL

>或 –

您可以从头设置小我私人防病毒/防火墙以应承毗连到Microsoft CRL

>或 –

您可以设置(公司的)防火墙,以便在会见Microsoft CRL的哀求时更快地向客户端发送超时.

>或 –

您可以在高级配置中将IE设置为不再“搜查宣布者的证书吊销”.

(详见上述博客1和2)

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!