Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Sizing Issues

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-11-11 : 08:03:16
Joe writes "Approximately what percentage of a hard drive should remain free for optimal database performance? I understand that a lot depends on table sizes and etc., but I am looking for a ballpark percentage.

Thanks."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-11 : 13:46:21
This isn't SQL Server related. Your server will run into performance problems if the free disk space gets around 5MB or so. 5MB is cutting it too close for me. I like to have at least 10-15% free at all times. In fact, we have alerts that occur when the space drops below this threshold.

Tara
Go to Top of Page
   

- Advertisement -