x

how to troubleshoot sql 2008 dropping connections

We successfully ran apps against databases on sql 2000 server. Now that the databases have been moved to sql 2008 r2, clients are intermittently dropped throughout the day. No hints in the error logs of Windows or SQL. Logged pings of server every minute shows max time of < 30 ms. Server runs under VMWare but is the only server on the host. Performance monitor shows system barely using available resources. What else could be causing this?

more ▼

asked Feb 14, 2011 at 10:16 AM in Default

avatar image

smeachum
32 2 4 5

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Can you explain the circumstance that you mention as "clients are intermittently dropped", do you mean they lose a network connection (ie they cant ping the SQL server) or that they lose database connectivity (ie a request for data from the client results in an error)?

A ping to the SQL Server will only confirm the network between the client and the server is good, sometimes only between the client and the server NIC rather than even the server OS. This wont confirm a link to the SQL server database engine, or to any specific database.

Are the clients successfully getting the data at times? Have any changes been made (or indeed not made, ie left at default on the new server) regarding connection pooling? Does the database have Auto_close turned off?

more ▼

answered Feb 14, 2011 at 11:10 AM

avatar image

Fatherjack ♦♦
43.7k 79 98 117

Clients do not lose network connectivity or even connectivity to the server there the app's .exe file is located. Only connection to the database is lost and it happens with various databases on the SQL server running different apps. Most often this happens during a period of inactivity on the client side, but some users have reported loss during data entry.

The ping time test was run because network interruption was suspected as a cause.

Clients have no problem connecting to the databases. Once the app is closed, the client re-starts the app and continues to work. The server was installed with default settings. Not susre where to set/change connection pooling. Max concurrent connections to the server is 0 (unlimited). Auto_close for the databases experiencing the most disconnects are all set to False.

Feb 14, 2011 at 11:23 AM smeachum

so what error do you get?

Feb 14, 2011 at 11:27 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

Hi

I now this is an old entry. Did you ever get an answer? I have the exact same situation.

more ▼

answered Nov 10, 2014 at 07:48 PM

avatar image

Hynne
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x57
x15

asked: Feb 14, 2011 at 10:16 AM

Seen: 3200 times

Last Updated: Nov 10, 2014 at 07:48 PM

Copyright 2016 Redgate Software. Privacy Policy