SoylentNews
SoylentNews is people
https://soylentnews.org/

Title    20 Years Since the Spread of the Microsoft Sapphire/SQL Slammer Worm
Date    Friday January 27 2023, @01:51PM
Author    janrinok
Topic   
from the windows-tco dept.
https://soylentnews.org/article.pl?sid=23/01/26/1558235

canopic jug writes:

Developer Robert Graham has written a retrospective on how his proprietary software was able to detect the Microsoft Sapphire Worm, also known as SQL Slammer as it hit due to his design choices. These choices were first, a poll-mode driver instead of interrupt driven and, second, protocol analysis for recognizing the behavior signature rather than pattern matching.

An industry luminary even gave a presentation at BlackHat saying that my claimed performance (2-million packets-per-second) was impossible, because everyone knew that computers couldn't handle traffic that fast. I couldn't combat that, even by explaining with very small words "but we disable interrupts".

Now this is the norm. All network drivers are written with polling in mind. Specialized drivers like PF_RING and DPDK do even better. Networks appliances are now written using these things. Now you'd expect something like Snort to keep up and not get overloaded with interrupts. What makes me bitter is that back then, this was inexplicable magic.

I wrote an article in PoC||GTFO 0x15 that shows how my portscanner masscan uses this driver, if you want more info.

When it hit in January 2003, the Microsoft Sapphire Worm, also known as SQL Slammer, began spreading quickly across the Internet by doubling in size every 8.5 seconds, infecting than 90% of vulnerable, networked Windows systems within 10 minutes.


Original Submission

Links

  1. "canopic jug" - https://soylentnews.org/~canopic+jug/
  2. "Robert Graham has written a retrospective on how his proprietary software was able to detect the Microsoft Sapphire Worm" - https://blog.erratasec.com/2023/01/im-still-bitter-about-slammer.html
  3. "doubling in size every 8.5 seconds" - https://www.caida.org/catalog/papers/2003_sapphire/
  4. "Original Submission" - https://soylentnews.org/submit.pl?op=viewsub&subid=58350

© Copyright 2024 - SoylentNews, All Rights Reserved

printed from SoylentNews, 20 Years Since the Spread of the Microsoft Sapphire/SQL Slammer Worm on 2024-04-19 07:30:38