2005 Management Studio in slow motion?

I'm running on a dual xeon development box.
Quite often, if I have Visual Studio 2005 up, the Microsoft SQL Server Mangement
Studio will run very slowly.
By slowly, I mean take 2 minutes to open up for modification a stored procedure.
If I run it alone, there is no problem.
What can I do to speed this up?
Thanks in advance, Les Caudle
1) How much ram on the box?
2) Does this occur just the first time the action is attempted or everytime.
The first time incurs a bunch of .NET startup crap.
TheSQLGuru
President
Indicium Resources, Inc.
"Les Caudle" <DotNetWannabe@.newsgroup.nospam> wrote in message
news:bi6a83lj26d12l9l6arcu2kkg6dca8pj8k@.4ax.com...
> I'm running on a dual xeon development box.
> Quite often, if I have Visual Studio 2005 up, the Microsoft SQL Server
> Mangement
> Studio will run very slowly.
> By slowly, I mean take 2 minutes to open up for modification a stored
> procedure.
> If I run it alone, there is no problem.
> What can I do to speed this up?
> --
> Thanks in advance, Les Caudle
|||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.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
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.
|||Wei - I'm using 32 bit XP Pro.
CPU usage is very low when this happens.
May be a memory issue, as the box only has 1GB (that used to be a lot).
I guess I'm surprised that it slows down to such a crawl at times, just for
certain operations,, while everything else runs at a normal speed, and only for
SQL Server.
Regards, Les Caudle
On Mon, 02 Jul 2007 02:39:13 GMT, weilu@.online.microsoft.com (Wei Lu [MSFT])
wrote:

>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.
|||Hello Les,
Thanks for the update.
I would like to suggest you add the physical memory to have a try and let
me know the memory usage.
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.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
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.