• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 755
  • Last Modified:

Slow connection on windows 7 PC to SQL 2008 database

I'm using sql server 2008 running on server 2008. When I load a new query in management studio on my windows 7 PC it take about 15 seconds to connect. However if I load a new query when on the server its almost instant, so the delay must be a network related issue. Any help with this is much apperciated.
0
corecc
Asked:
corecc
6 Solutions
 
tigin44Commented:
do the server and pc in the same domain?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> When I load a new query in management studio on my windows 7 PC it take about 15 seconds to connect.

Kindly confirm the following:

1. SQL Server load at that time when you tried to connect
2. Memory resources and any other application running in Windows 7.

Use sp_who2 or activity monitor to find out the reason..
0
 
cralCommented:
Try this fom cmd (as admin), restart and test speed:
netsh int tcp set global autotuninglevel=disabled
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
coreccAuthor Commented:
the server and pc are both in the same domain
load and memory seem normal at time of connection on both the server and the desktop
tried disabling auto tunning, made no difference.

any other ideas?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> However if I load a new query when on the server its almost instant, so the delay must be a network related issue.

Try running the same query directly in your SQL Server 2008 machine to confirm this out..
0
 
coreccAuthor Commented:
I have done, and it connects straight away.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
And what about the total time taken for the execution of query in both cases..
0
 
coreccAuthor Commented:
almost instant on the server and about a 15 second delay on the client
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Seems like a problem with your SQL Server client in your machine.
Kindly apply SP1 for your SQL Server 2008 and test it out once..

Kindly let me know whether this works instantaneously using SQLCMD to confirm this by typing the one in command prompt

SQLCMD -S servername -U username -P Password -Q "your query"
0
 
coreccAuthor Commented:
the problem related to the tcpip connection using named pipes fixed the issue.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now