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.
| Author |
Topic |
|
jfegley
Starting Member
2 Posts |
 Posted - 2009-10-22 : 10:43:17
|
| Hey all,I've been looking for some general best practices for SQL database:log_file ratios but am having trouble finding any resources that touch on this subject.Basically I'm about to roll a new SQL server and am trying to determine how I should allocate the storage for the data volume and the log volume. I was hoping I could get some opinions from you guys (and girls). Any advice and/or insight would be greatly appreciated.Thanks!Joe |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-10-22 : 13:19:55
|
| A good starting ratio is 25%, but it really depends on how big your transactions are. One thing that greatly impacts the tlog size is database maintenance such as rebuilding indexes. I've had tlogs that are about the same size of the data files. One other thing that will impact tlog size is how often you run tlog backups. We run ours every 15 minutes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
jfegley
Starting Member
2 Posts |
Posted - 2009-10-23 : 09:30:02
|
| Thanks for the info, that should be very helpful. So just to make sure I'm clear you're saying that if I give 200GB for the data volume then 50GB should be a good starting point for my log volume?Thanks,Joe |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Best practices for Database/log ratio