Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a web application using an ISAPI filter (written in c\c++) and OleDB to connect to a SQL Server 2008. The application works fine on a certain number of Windows Server 2008 R2.

Recently I found another server, also Windows 2008 R2, where the application is really slow.
I wrote a simple console application using C# and OleDB and I found it is really slow when executing a simple query like SELECT GETDATE(). I figured out that the something is wrong at the OleDB level, but I'm now stuck.

SQL Server is installed on a different server on the same subnet and there are no firewalls between the Web Server and SQL Server.

My test environment was:
S1: server 2008 (64bit)
S2: server 2008 (64bit)
S3: server 2003 (32bit)

all servers were running SQL Server 2008 and are on the same network (using a switch)
I ran my C# application executing SELECT GETDATE() in the following configuration (the first server is where the C# app is running, the second is where SQL SERVER is)

S1 -> S1 <1ms
S1 -> S3 5ms
S1 -> S2 300ms
S2 -> S2 <1ms

Any idea on how to proceed in the investigation?

share|improve this question
    
What is slow to you? What is it you figured out at the OleDB level? Where exactly are you stuck? A bit more detail would help you get the answers you need. –  TylerShads Feb 5 '12 at 2:29
    
@TylerShads My test environment was: S1: server 2008 (64bit) S2: server 2008 (64bit) S3: server 2003 (32bit) all servers were running SQL Server 2008 and are on the same network (using a switch) I ran my C# application executing SELECT GETDATE() in the following configuration (the first server is where the C# app is running, the second is where SQL SERVER is) S1 -> S1 <1ms S1 -> S3 5ms S1 -> S2 300ms S2 -> S2 <1ms –  Stefano Feb 6 '12 at 7:39
    
Now add that to your question instead of a comment :) –  TylerShads Feb 6 '12 at 13:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.