November 27, 2012 at 3:13 am
Dear Everyone,
We had a network issue this morning, which resulted in extraordinary levels of network traffic for a short while. A Virtual Windows server, which happens to host our most important instance of SQL Server, responded by shutting down its SQL Server service.
I would like to understand why this happened. My best guess is that the shut-down was defensive and was instigated by the Operating System, but I don't know for sure. Can anyone help?
Thanks in advance to all who reply,
Mark Thornton
November 27, 2012 at 6:51 am
Server responses to overwhelming amounts of network traffic are often unpredictable. That's why DDOS attacks are a favorite cyber-terror tool (like the "hacking" that Anonymous does, which is mainly just script-kiddie style use of LOIC for DDOS).
Do a bit of research on DDOS. There are ways to mitigate the effects. If you're worried about the network going crazy again, you can implement safeguards against it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 28, 2012 at 6:43 am
In addition to what GSquared said I would also check to see if TCP Chimney was enabled. This is a not-good thing for SQL Server boxes.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 28, 2012 at 8:03 am
I know this contrary to what everyone else has said but I've experienced similar behavior when a RAM module was going bad. Everything seemed fine until either the connections or CPU went through the roof. Something to think about...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:37 am
i am surprised why not anybody refer here machine's event viewer(log ) or ot doesnt help in cases of vm machines :unsure:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2012 at 8:44 am
I always assume those steps are performed before someone even posts to the forum :w00t:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply