November 8, 2012 at 3:07 pm
Hi Everyone,
We have a database (2.5 Tera Byte), and it is in SQL SERVER 2008 R2,which is being hited heavily.The transaction log file size is 90GB(only 10% of it isbeing used).currently we have 1976 VLF for our transaction log file.What is the best VLF for this database?What are the steps for doing that?
Thanks
November 8, 2012 at 3:11 pm
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 9, 2012 at 4:57 pm
You should likely have a lot less than 1976. It sounds like you may have let autogrow run wild in the database. Read the articles Gail posted and devise a strategy and some downtime to shrink your logs and re-grow them so the number and size of your VLFs are more appropriate for your log file size and recovery needs.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply