Lettered Drive Free Disk Space

Question

Lettered Drive Free Disk Space

SW_Lindsay

SSCommitted

Points: 1983
More actions
February 15, 2010 at 7:38 am

#138755

Sorry if this in in the wrong place...
My system administrators would like me to reccomend the best way to create a threshold for free space on lettered disks. This is not free space inside of SQL Server but on a disk drive. Is it better to use a percentage and what would be a good number 5%, 10% or a fixed amount like 5 GB or 10 GB. They are looking for a universal rule and best practice.
Thanks for the advice,
Steve

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

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

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

IMO it should be more that 10%, on a NTFS volumn the OS reserves 10% for the journal. Once data starts to eat into the 10% then you can get performance problems.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

I like my thresholds a little higher. 25%

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 3

Percentages? Even on Tera-byte drives?

--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)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Jeff Moden (2/15/2010)
Percentages? Even on Tera-byte drives?

Yeah - kind of archaic I know. More of a precaution for me though. I like to be alerted when that drive / lun is approaching capacity well in advance. I have experienced a lun being filled over night (400GB free gone like that) due to some heinous app. The irony is that everybody knew that the app did this from time to time - but we got grief for mentioning that that app was the cause. Better safe than sorry - and better paranoid than safe?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events