Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
net_csb
Starting Member
3 Posts |
 Posted - 2008-02-29 : 11:56:12
|
| 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 reponse 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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:54:26
|
| Do you connect to sql server with tcp/ip protocol? Tried connect with ip address and port number? |
 |
|
|
net_csb
Starting Member
3 Posts |
Posted - 2008-03-06 : 12:04:48
|
| 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 |
|
|
|
|
|
|
Slow response from a 32 bit to 64 bit connection.