AJ

Management studio開啟過長的問題，建隆(朋友)找到了一些資訊跟各位分享一下
1. http://www.sql-server-performance.com/faq/sql_server_management_studio_load_time_p1.aspx
2. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657867&SiteID=1
簡單的說明一下
發生原因(http://support.microsoft.com/kb/918644/zh-tw)
之所以發生這個問題，是因為受影響的電腦無法連線至 http://crl.microsoft.com (http://crl.microsoft.com) 網站。這個問題是因為下列情形而造成：
 當 Microsoft .NET Framework 啟動 SSIS 服務時，.NET Framework 會呼叫 CryptoAPI 函數以確認指派給 SQL Server 組件檔案的憑證。
 CryptoAPI 函數會檢查可在 http://crl.microsoft.com (http://crl.microsoft.com) 網站上取得的「憑證撤銷清單」(CRL)。這個動作需要網際網路連線。
 如果網際網路連線遭到封鎖，可能會捨棄傳出的 HTTP 要求，因而不會傳回錯誤訊息。此外，長延遲會造成 CRL 檢查逾時。「服務控制管理員」(SCM) 判斷 SSIS 服務花太長的時間啟動。因此，SCM 會回報錯誤訊息，而 SSIS 服務也不會啟動。
 
解決步驟有三種:
1. Configure a proxy server to allow access to http://crl.microsoft.com from your server
2. Configure your firewall to return a failure status quickly when it blocks access to the http://crl.microsoft.com website
3. Disable checks for certificate revocation.  You can do this using Internet Explorer by opening the Interet Options dialog,
going to the Advanced Page, and then unchecking the "Check for publisher's certificate revocation" checkbox. 
There are fraudulently signed binaries in the wild that can make virus-infected applications look like they were published by Microsoft. 
Disabling this check should probably not be done on machines with internet access.