SQL SERVER latency issue on new laptop - simple select of small table 7 seconds

Question

SQL SERVER latency issue on new laptop - simple select of small table 7 seconds

lklein

Ten Centuries

Points: 1234
More actions
November 16, 2010 at 3:39 pm

#144157

I've tried searching and all latency issues are much more complex. I have a new (to me) lap top with Sql Server 2005 and when I run a simple query of Select * from table where table has 10 records it takes 7 seconds to return.
I logged onto the same server and it returns in miliseconds.
Any thoughts? I compaired setting on the server version to mine and they appear the same. I didn't have this issue on my old laptop.
Please help!

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

Please clarify. You have SQL 2005 SSMS installed on the laptop and you're connecting to the server, or you have a desktop SQL Engine running on your laptop running the 2k5 engine and you're querying that?

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

lklein Ten Centuries Points: 1234 More actions · Answer 2

lklein

Ten Centuries

Points: 1234

November 16, 2010 at 4:00 pm

#1251632

2005 SSMS

lklein Ten Centuries Points: 1234 More actions · Answer 3

But I did remote into that server and didn't have the issue. Same for all servers - slow. So it's just my machine. It's like it's verifying who I am - never returns promptly. I just created a simple select proc and it took 8 seconds.

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 4

Are you on the same domain, or are you VPN'ing in? It sounds like the VPN is doing something strange that you don't get when you're RDC'd.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

lklein Ten Centuries Points: 1234 More actions · Answer 5

No I'm not vpn'ed in - but that what it feels like.

David Webb-CDS SSCoach Points: 17398 More actions · Answer 6

How much memory does it have? If the server and SSMS are fighting for the memory, you may see latency based on the need to swap out the server for the management app or swap out the management app for the server. That's why connecting from somewhere else might not exhibit the same problem. More memory might help, or setting SQL Server's max memory low enough to ensure enough is left for the management console might be easier.

And then again, I might be wrong ...
David Webb

lklein Ten Centuries Points: 1234 More actions · Answer 7

So what would I set it to. I will definitely try that.

lklein Ten Centuries Points: 1234 More actions · Answer 8

I set the min and max to the default (my min was 1248?) now a simple select from a table of 125 rows just took 20 seconds. I just made it worse. I restarted SSMS so now it's back to the 7 seconds on a simple select.

lklein Ten Centuries Points: 1234 More actions · Answer 9

Not sure what difference it makes but my old machine was Vista 32 bit and my new one is Win 7 and 64 bit.

Thanks in advance for any assistance...