February 27, 2007 at 9:22 am
Our Prod SQL 2005 server is experiencing timeouts and error establishing connection errors. This is happening ever since more people are using the web site. Our web site is written in ASP .Net 2.0. How do I go about figuring out what the problem could be? Below are a couple of sample error messages. Not everyone gets these errors ... but at some time it looks like several people seem to get timeouts at the same time. Any tips are greatly appreciated. Thanks.
--------------------------------------------------------------------------
Message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
Source: .Net SqlClient Data Provider
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)
--------------------------------------------------------------------------
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source: .Net SqlClient Data Provider
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)
February 27, 2007 at 11:00 pm
Enable remote connections in SQL server 2005 Surface Area Configuration (SAC)...
Run the sql trace and enable error and warning and check for long running queries too...
MohammedU
Microsoft SQL Server MVP
March 18, 2007 at 5:18 pm
Along with Mohammed's suggestion, take a peek at resource utilization on your db server, as well as your web server driving the client side (assuming they are two different boxes). In your ASP.NET configuration in IIS, make sure you are using connection pooling and that you are using it properly.
For more information on connection pooling, the following link should be helpful:
http://www.15seconds.com/issue/040830.htm
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply