September 25, 2003 at 12:55 am
What is the best or recommended percentage of data and log file size in a database,if we want to restrict the database size? Is 75% for data and 25% for log is Ok ? Please let me know if anyone has any advice and reason for that.
September 25, 2003 at 1:58 am
It depends.
We have an application where it is 2:1 and one where it is 10:1
Without logging mode the logfiles can be much smaller.
With logging mode it depends on the log backup time.
But above all it depends on the use of the database.
Lots of changes need more logging.
Keeping all the data for ever needs larger data files.
If size is an issue use autogrow. Let the database decide for itself.
Joachim.
September 25, 2003 at 2:00 am
How long is a piece of string?
You need to do a proper sizing exercise.
If you have a lot of static data i.e. very few changes, then a comparatively small log file will do.
If you have very volatile data i.e. lots of changes, then you will need a comparatively bigger log.
You need to factor in other things, such as, are you using full or simple recovery, and if full recovery, how often will the transaction log be backed up etc etc.
September 30, 2003 at 3:27 am
I don't think it is a question of percentage between MDF and LDF.
If you use simple recovery model , the size needed for the LDF depends on the biggest amount of data being updated by simultaneous transactions.
If you use full recovery model , the size depends on the previous factor plus the frequency of your transaction log backups
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply