Re: SQL thinks it's Slammer

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?


.

Relevant Pages

  • Re: Static IP On WInXP machine? Is it possible?
    ... ip requests from the internet. ... OR does the sql server need to be installed ... on the Windows 2000/2003 server OS before the static IP can work? ... In other words use something like a Web Service or Data Service to deal with the requests and pass data to / from SQL Server. ...
    (microsoft.public.sqlserver.msde)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)