We help IT Professionals succeed at work.

SQL Server Management Studio Express 2008 very slow in Windows 7 pro 64

1,494 Views
Last Modified: 2012-05-10
Hi all,

I'm finding sql server management studio expres painfully slow in a windows 7 pro 64.

This is the info from the about window...
---------------------------
Microsoft SQL Server Management Studio                                    10.50.1600.1
Microsoft Data Access Components (MDAC)                                    6.1.7600.16385
Microsoft MSXML                                    3.0 4.0 5.0 6.0
Microsoft Internet Explorer                                    8.0.7600.16385
Microsoft .NET Framework                                    2.0.50727.4952
Operating System                                    6.1.7600
---------------------------

Any thoughts?
Comment
Watch Question

My initial guess would be that it's a hardware issue.  What are the computers specs?  You may not have enough RAM.

Author

Commented:
I have an HP dv7-4053cl very fast.
4 Gbytes of RAM
when I work with Visual Studio connected to the same database/table it just
works at a good speed, with the same machine. It is a software problem, maybe a question of having SSME 32 in a 64bit OS?
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
You can disable LLMNR by performing following steps


Modify Group Policy – Go to Search – Type GPEdit.msc – Enter – Navigate to the following and make sure Enabled is checked -


Computer Configuration\Administrative Templates\Network\DNS Client
\Turn off Multicast Name Resolution = Enabled

Author

Commented:
Didn't solve the problem in full
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.