Disk space gets full and cluster goes offline

Question

Disk space gets full and cluster goes offline

Ryan007

SSCrazy Eights

Points: 8275
More actions
November 11, 2013 at 7:59 am

#300834

Hi,
We have 2 node cluster in windows server 2003, sql server 2000. Drives are allocated from net app. When the disk in cluster gets full, whole cluster goes down. Anybody faced similar issue before? Any idea how disk full takes the disk offline?
Ryan
//All our dreams can come true, if we have the courage to pursue them//

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233918 More actions · Answer 1

at the Netapp filer level if the LUN space depletes the LUN goes offline, this in turn will take the disk offline in Windows.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 2

Thanks Perry

But disk might get full due to huge transactions. So to prevent this, is there anything that can be done so that LUN does not go offline if the disk goes full like kind of creating reserve space in LUN or anything else.

Please advice.

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Perry Whittle SSC Guru Points: 233918 More actions · Answer 3

Ryan007 (11/11/2013)
Thanks Perry
But disk might get full due to huge transactions. So to prevent this, is there anything that can be done so that LUN does not go offline if the disk goes full like kind of creating reserve space in LUN or anything else.
Please advice.

Increase your lun size, sounds like it needs it!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

dan-572483 SSCoach Points: 15870 More actions · Answer 4

A short term solution might be to configure maximum data and log files sizes to the disk can't fill up. You'll still have problems, but at least the cluster won't go down and you can address them.

Jeff Moden SSC Guru Points: 1003895 More actions · Answer 5

Ryan007 (11/11/2013)
Thanks Perry
[font="Arial Black"]But disk might get full due to huge transactions[/font]. So to prevent this, is there anything that can be done so that LUN does not go offline if the disk goes full like kind of creating reserve space in LUN or anything else.
Please advice.

You have correctly identified the problem. I recommend you check the code that does that and find out why.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)