Link to home
Start Free TrialLog in
Avatar of eblumenfeld
eblumenfeldFlag for United States of America

asked on

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

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?
Avatar of Dustin99352
Dustin99352

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

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of hamlin_stephen
hamlin_stephen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Didn't solve the problem in full