Re: SQL Resets
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 2 Sep 2009 22:03:27 +0000 (UTC)
CQL Users (CQLUsers@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
We have a web environment that has multiple WEB fronts hitting a SQL 2000
Server with SP4. (Windows 2003 Server).
We are using the connection pooling, so it's not the maxuserport setting
in the registry.
From time to time, under heavy loads, we are getting resets at the TCP
level on SQL connections from the Web server.
I'll get the RST, ACK flag in the TCP packets and the web application will
throw an exception in the web app, but only under heavy loads.
My question, what would cause the RST, ACK in the TCP packet and what
might I look for to troubleshoot this further?
Since I'm in a bit of hurry now, I will only give you a keyword to
search for on Google: SynAttackProtect. It sounds like this is your
issue.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: SQL Resets
- From: CQL Users
- Re: SQL Resets
- From: CQL Users
- Re: SQL Resets
- From: CQL Users
- Re: SQL Resets
- References:
- SQL Resets
- From: CQL Users
- SQL Resets
- Prev by Date: Re: Unable to run SQL 2005 query against linked SQL 2000 database
- Next by Date: Re: SQL Resets
- Previous by thread: SQL Resets
- Next by thread: Re: SQL Resets
- Index(es):
Relevant Pages
|
