June 25, 2009 at 8:34 am
I have my database set to autogrow. I understand that it will continue to grow until it reaches the limits of the hard drive with autogrow on. But my question is...is that the limits of the c:hard drive (where the operating system is). or the other hard drive where the data and log files are?
My database is 9GB. The drive that has the log and data files have 64GB free. But the hard drive has only 8GB. The application users plan to increase the amount user can upload to 50MG per person. I'm not really worked about the drive that holds the log and data files but the c:drive is only 8 GB.
June 25, 2009 at 8:44 am
New_to_being_DBA (6/25/2009)
I have my database set to autogrow. I understand that it will continue to grow until it reaches the limits of the hard drive with autogrow on. But my question is...is that the limits of the c:hard drive (where the operating system is). or the other hard drive where the data and log files are?My database is 9GB. The drive that has the log and data files have 64GB free. But the hard drive has only 8GB. The application users plan to increase the amount user can upload to 50MG per person. I'm not really worked about the drive that holds the log and data files but the c:drive is only 8 GB.
it is the Data Drive with Data and Log Files.
Keep resonable space on the Data Drive and also on c ddrive, as by default this is the drive where the windows page file is located and needs space to grow as the infomation grows.
Good practise about Data File is to mange the Autogrow feature as it grows:
EG: if the Database is 20GB, reduce the auto grow to 5% from 10% so the Db grows 1GB at a stretch... this will help manage the database space... also the Log files need to be managed, but shrinking the log Files at regular intervals... if the database is highly transactional, keep it in FULL Recovery MODE else reduce it to SIMPLE.. but again log growth will happen under certain curcumstances...
Maninder
www.dbanation.com
June 25, 2009 at 2:45 pm
EG: if the Database is 20GB, reduce the auto grow to 5% from 10% so the Db grows 1GB at a stretch...
Rather than adopting the above methos try specifying autogrowth in MB's rather than as a percentage.
MJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply