Re: SQL thinks it's Slammer
- From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 20 Feb 2006 20:53:27 -0600
Take a look at the Windows layer. I can't remember where it is, but there
was something built into Windows 2003 that essentially recognizes a huge
volume of traffic and starts denying TCP requests. This is a DDOS attack
prevention mechanism.
I've run into this once before at a customer having unexplained issues which
were basically general network errors after upgrading to SQL Server 2005.
It turned out that SQL Server was able to handle so many more requests per
unit time, that the request load increased above some threshold. So Windows
started denying requests, because it thought it was a DDOS attack instead of
valid user traffic. There is a KB article with some guidance on it
somewhere.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C2190C0-AA5A-4312-A3CC-85B70ED454E0@xxxxxxxxxxxxxxxx
Can SQL server 2000 think that the slammer virus is affecting it and start
shutting it's services down, or limiting it's service? I was told that sql
2000 SP4 has the slammer fix, and if multiple queries are used the SQL
server
thinks it's the slammer virus. Is this true? Is there a way to prevent
this
if so?
.
- Prev by Date: SQL server 2000 and active directory login
- Next by Date: Re: SQL2005 Allow Login Limited Visibility
- Previous by thread: Re: SQL thinks it's Slammer
- Next by thread: Re: Adding role to roles?
- Index(es):
Relevant Pages
|
|
