SQL Server Performance

Too many timeouts and error establishing connectio

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by exBK, Feb 27, 2007.

  1. exBK New Member

    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)
  2. jezemine New Member

    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
  3. satya Moderator

    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.

Share This Page