Showing results for 
Search instead for 
Did you mean: 
Level 7

Recommendations for Transaction Log size/growth rate?

Does anyone have any experience or recommendations in regards to the growth rate and limitations we would place on the Transaction Log for the Faultline DB?  There are SQL Server defaults for this: 25% and limited to ~3GB, but if the product actually requires more than that, I don't want to impact performance for larger deployments.  Do we have any "resting" targets, such as 10%-30% of the size of the Faultline.mdf?

0 Kudos