August 30, 2005 at 1:51 pm
HI. We are setting up a brand new server for sql server. Therre about 266 g to work with. I was planning on putting the datafiles on a drive by itself and the log files on another driver by itself. Is there a rule of thumb as to how much space should be given to log files?
Juanita
August 30, 2005 at 2:02 pm
The old school (pre SQL7) line of thinking was that you wanted your log files to be at least 25% of the size of your data file but with dynamic file growth performed by SQL Server, I don't know that this really applies anymore. It is really going to depend on a combination of 1) how transaction intensive your application is and 2) how often you perform log dumps.
If it were me, I'd set the log file up at say 100 megs or so and then enlarge it to a percentage of the data file size. After some tesing, you should be able to tell how large the active portion of the log is and how it grows under a load and you can then size appropriately. You don't want to make the initial size too large as you won't be able to ever shrink it smaller than its initial size without dropping it.
My hovercraft is full of eels.
August 30, 2005 at 2:42 pm
Thank you so much ! Great advice
Juanita
September 1, 2005 at 11:43 am
I agree with sswords to a point ... the old school method of 25% was usually a starting point. Monitoring growth and usage are musts along with adjusting the frequency of transaction log backups if you are in 'full' recovery mode. However I would stay away from autogrow at the 'default' level. There a numerous articles that document it's potential performance issues. I'd starty with a 25% size and allow it to 'autogrow' once (50% growth) fopr starters and then fine tune from there. Just because it's 'new and improved' and does it for you 'auto-magically' does not neccessarily mean that it is the best.
Learn 'the method' then apply it with the 'tool' ... not learn 'the tool' and apply it's 'method' !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply