RE: 2005 Management Studio in slow motion?
- From: weilu@xxxxxxxxxxxxxxxxxxxx (Wei Lu [MSFT])
- Date: Mon, 02 Jul 2007 02:39:13 GMT
Hello Les,
I would like to know whether you are using 64 bit machine for Xeon.
I found some related issue which you may refer:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657867&SiteID=1
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
start up time for Management Studio.
There are a couple workarounds:
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.
http://support.microsoft.com/kb/906892/en-us
You may experience slow performance when you run 32-bit SQL Server tools on
64-bit operating systems
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- Re: 2005 Management Studio in slow motion?
- From: Les Caudle
- RE: 2005 Management Studio in slow motion?
- From: Wei Lu [MSFT]
- Re: 2005 Management Studio in slow motion?
- Prev by Date: Re: Enter Today's Date in SSMS Open Table Grid View
- Next by Date: Re: Benchmark workload
- Previous by thread: Enter Today's Date in SSMS Open Table Grid View
- Next by thread: RE: 2005 Management Studio in slow motion?
- Index(es):
Relevant Pages
|