onsdagen den 11:e februari 2009

Too many VLF:s or to few?

I found an excellent blog post by Kimberly L. Tripp yesterday about transaction log performance and VLF:s. I later investigated a couple of our own databases that I have taken over and they are clearly in need of a little bit more maintenance then I have done so far.
The recommendations are maybe around 50 or a little bit more depending on the size of the db/log. I found out that we had over 3000 VLF:s in one medium sized database. This is however quite easy to fix. The secret is capacity planning to avoid this problem.

Here are the full article from Kimberly.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Happy reading
Stefan


0 kommentarer: