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?
asked Feb 14 '11 at 10:16 AM in Default
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?
answered Feb 14 '11 at 11:10 AM