Too many timeouts and error establishing connectio | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Too many timeouts and error establishing connectio

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)

sounds like your prod server is exceeding capacity. options are: 1. detect and fix non-performant code to free up resources (use profiler to find slow queries)
2. share the load between multiple servers
3. buy bigger hardware www.elsasoft.org

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19801 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>