March 21, 2012 at 11:07 am
Here is my problem:
It takes about 20 seconds for the client application to connect with the sql 2008 database instance even though the client and the server are in the same LAN network! Once connected, application works seamlessly with the database with little latency.
Also, using ODBC , the client pc can instantaneously connect with the database .
Any idea why there is so much lag for the application to connect with the database? Any insight into diagnose this problem will be greatly appreciated.
Are there any log files in the sql server that shows what is happening during the 20 seconds it takes to connect??/
March 21, 2012 at 11:13 am
Let's backtrack a bit... What is the ping time between the application server and the database server from command prompt?
Jared
CE - Microsoft
March 21, 2012 at 11:19 am
Ping time to the database server is 1 ms or less.
March 21, 2012 at 11:27 am
Is the application running off an application server or the client desktop?
March 21, 2012 at 11:36 am
The application is installed in the client PC. There is a specific connection file provided/configured by this app to connect with the database.. I can connect to the db with this connnection file but the delay is driving me crazy:crazy:
March 21, 2012 at 11:52 am
jpbbabin (3/21/2012)
The application is installed in the client PC. There is a specific connection file provided/configured by this app to connect with the database.. I can connect to the db with this connnection file but the delay is driving me crazy:crazy:
Which driver are you using to connect? What is the connection string? Are you using something like FreeTDS?
Jared
CE - Microsoft
March 21, 2012 at 12:00 pm
Well, it is third party app. The app's connection file contain just basic information like the server name, database instance name, user, psw etc. I cant see the exact connection string or dont know the driver they are using...
March 21, 2012 at 12:01 pm
I am thinking DNS issue....
March 21, 2012 at 12:03 pm
When you did the ping, did you use IP or server name? If you used servername and it was fast, then I think it probably something to do with the driver the software is using to make the connection. You really need to know what that is...
Jared
CE - Microsoft
March 21, 2012 at 12:20 pm
Jared,
Yes, I used the server name when i pinged and it was fast..What do you mean by the driver? Do you mean a client similar to ODBC that this app may be using aid connection? Any idea how to check what driver they may be using??
Also, since i was able to instantaniously connect to the db using ODBC, i am also leaning it is a software issue but cant pin point.. But i am not suring certain settings for enabling TCP/IP connection or named Pipes need additional configuration to connect via non ODBC....
March 21, 2012 at 12:26 pm
Yes, that's exactly what I mean. I'm not sure how to check which they are using, but there are several out there that can have issues. Maybe someone else can help with how to see what it is using to connect.
Jared
CE - Microsoft
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply