Slow response from a 32 bit to 64 bit connection.

Question

Slow response from a 32 bit to 64 bit connection.

Chandra-149818

SSC Enthusiast

Points: 130
More actions
February 29, 2008 at 10:01 am

#120559

Here is the configuration we have at our site:
64 bit virtual server - Clustered 64-bit SQL Server 2005 Standard SP2 listening on port 1433.
32 bit virtual server - 32-bit application that connects to above SQL Server 2005 via standard OLEDB driver installed with windows (String utilized: Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=applicationdb;Data Source=ServerInstanceName).
We are experiencing a slow response of 45 sec to more than a minute on a simple select statement on a table having 5000 rows.
The same select statement on the Server locally in Studio returns results back in 2 seconds or less. But from Stuido on any other desktop (remote) it takes 45 secs or more. Same slow response is seen by the application which is using OLEDB.
I've looked into some of the Server parameters but didn't find any clues.
Any help is greatly appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 1

I'd start w/ the network adapter on the active node - are you running 100mbps or 1000mbps? Full duplex? What is the response when running a tracert? Good luck 🙂

Tommy

Follow @sqlscribe

Chandra-149818 SSC Enthusiast Points: 130 More actions · Answer 2

tracert gave 1ms and verified with iperf tool and there is no loss in bandwidth between server and the client machine.

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 3

check you have all network cards running full duplex, not auto. Sounds like ad problems to me.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Chandra-149818 SSC Enthusiast Points: 130 More actions · Answer 4

It was my PC connected from the switch via a 100 Mbps router was showing 100 Mbps on my machine. On the other end it was actually connected to 10 Mbps. We only found it after running iperf tool on couple other desktops of same configuration and realized my desktop is having 8 mbps bandwidth while others have 700 plus.

Thanks for your help