Avatar of eblumenfeld
eblumenfeld
Flag 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?
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
eblumenfeld

8/22/2022 - Mon
Dustin99352

My initial guess would be that it's a hardware issue.  What are the computers specs?  You may not have enough RAM.
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
hamlin_stephen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
hamlin_stephen

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
eblumenfeld

ASKER
Didn't solve the problem in full