April 20, 2013 at 12:32 am
Hi,
I am using sql server 2008 r2 express.I heard virtual log file count may be the problem for server performance.I searched sometime but i didn't come up with optimum VLF count.Some says it depends.Can anyone please help me to find out optimum VLF count for my databases
Thank you
April 20, 2013 at 1:03 am
As you said it depends. Sql itself creates VLFs and it determines the size. what we have to do is we have to keep this VLF count as small as possible.if there are lot of small size VLFs in your log file then it takes lot of time for backups and restores. this is what i know. please check books online for further information.
April 20, 2013 at 3:09 am
Hi
If you maintain your log file on the best then you're close to the optimal number of VLFs. This link can help you http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply