December 1, 2009 at 9:10 am
Guys I would like to know how do you determine how big the log file will be for a given database let's assume you have a 10 gig database file. Also how do you configure sql server notifications to notify you of various events for example let's say you have disabled auto grow and you have a 10 gig log file you want to be emailed before you run out of log space. BTW I'm using sql server 2008
December 1, 2009 at 9:33 am
I did read in some best practices to have the log file of size 20% with respect to your database. In this case of db file, it would be roughly 2 Gigs.
This is an estimate and it depends on how better (shorter) the transactions are performed, along with the recovery model and the log backups frequency.
Regarding alerts, you can set up custom jobs in SQL server monitoring the file sizes and disk sizes, also there are certain monitoring applications that alert on disk space being low etc etc...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 2, 2009 at 7:30 am
Bru has provided some good advice. The 20% of database file size is a guideline to get you started, but if you have a terabyte database do you really need a 200GB log file, probably not. Also, I'd recommend leaving autogrow on for emergency situations, sure still monitor the size and manually grow if needed, but do you want the database stopped because you missed an alert?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply