Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server responds to overwhelming network traffic by shutting down Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 3:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:39 AM
Points: 68, Visits: 153
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
Post #1389046
Posted Tuesday, November 27, 2012 6:51 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1389167
Posted Wednesday, November 28, 2012 6:43 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 4,356, Visits: 6,189
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 at GMail
Post #1389725
Posted Wednesday, November 28, 2012 8:03 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 3,931, Visits: 7,158
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; They'll drag you down to their level and beat you with experience"
Post #1389809
Posted Wednesday, November 28, 2012 8:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
i am surprised why not anybody refer here machine's event viewer(log ) or ot doesnt help in cases of vm machines

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1389847
Posted Wednesday, November 28, 2012 8:44 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 3,931, Visits: 7,158
I always assume those steps are performed before someone even posts to the forum

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1389856
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse