asked on

SqlServer Management Studio 2008 very slow

Hello,

I have changed from SSMS 2005 to SSMS 2008 on my notebook.
If I access a SqlServer 2008 of a customer from me via vpn-connection then the ssms is very slow. I mean not the excution of the query but the query editor.

Previously on the ssms 2005 I doesnt have the problems.

Can you help me?

Thanks
Reiner

Anthony Perkins

Since your notebook may not be sufficiently powerful to handle the new features in SQL Server 2008, you may consider disabling intellisens:
Tools | Options, Text Editor, Intellisense.

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

k_murli_krishna

Here are some very good references:

FAQ, WHY DOES SSMS TAKE 45S TO START UP?
http://blogs.msdn.com/euanga/archive/2006/07/11/662053.aspx
When running "SQL Server Management Studio" the application may load slowly.
http://support.microsoft.com/kb/555686
SQL Server Management Studio Startup Time
http://blogs.msdn.com/dtjones/archive/2006/08/23/sql-server-management-studio-startup-time.aspx
SQL Server Management Studio Express very slow
http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/4bb541d3-2370-40c6-b25c-ffbc038d0ee9

seffer

ASKER

Hello,

thank you acperkins, it's a litte bit better. But the notebook has enough power, the problem is only on remote Databases. On local databases no problems.

Have you any other ideas?

Thank you
Reiner

Anthony Perkins

I am afraid not.

seffer

ASKER

the problem is not complete solved