SQL Resets

Tech-Archive recommends: Fix windows errors by optimizing your registry

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?
.

Relevant Pages

  • Re: TDS vs. TCP
    ... That's true in stand-a-lone server but in Cluster where SQL is a Virtual ... I see both TDS and TCP packets where in the TDS packets the ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Resets
    ... Tried applying the SynAttackProtect and that didn't seem to touch it. ... Server with SP4. ... level on SQL connections from the Web server. ... ACK flag in the TCP packets and the web application will ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Resets
    ... Server with SP4. ... We are using the connection pooling, so it's not the maxuserport setting ... level on SQL connections from the Web server. ... ACK flag in the TCP packets and the web application will ...
    (microsoft.public.sqlserver.connect)
  • Re: Application Role
    ... eavesdrop on the actual conversation Access is having with the SQL ... >While performance is not an issue so far with some 25 users and a big server ... >> more info on the connection pooling issue. ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)