SQL Server responds to overwhelming network traffic by shutting down

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server responds to overwhelming network...

SQL Server responds to overwhelming network traffic by shutting down

Rate Topic

Display Mode

Topic Options

Author

Message

MarkThornton

Posted Tuesday, November 27, 2012 3:13 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:33 AM
Points: 65, Visits: 135

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

GSquared

Posted Tuesday, November 27, 2012 6:51 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

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

TheSQLGuru

Posted Wednesday, November 28, 2012 6:43 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 3,580, Visits: 5,122

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

MyDoggieJessie

Posted Wednesday, November 28, 2012 8:03 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 2,037, Visits: 3,761

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" Wink

Post #1389809

Bhuvnesh

Posted Wednesday, November 28, 2012 8:37 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

i am surprised why not anybody refer here machine's event viewer(log ) or ot doesnt help in cases of vm machines Unsure

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1389847

MyDoggieJessie

Posted Wednesday, November 28, 2012 8:44 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 2,037, Visits: 3,761

I always assume those steps are performed before someone even posts to the forum w00t

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" Wink

Post #1389856

« Prev Topic | Next Topic »

Permissions