读[Pro.SQL.Server.2005.Replication]的点滴心得1

summerain

于 2009-10-22 17:17:00 发布

阅读量749

点赞数

分类专栏：技术心得文章标签： sql server optimization performance 优化 file less

本文链接：https://blog.csdn.net/summerain/article/details/4714170

版权

技术心得专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1. 将VLFs保持在50以内可以优化事务日志读和写的性能.值得测试下. <826>

You can monitor the number of VLFs and keep the number as low as possible. For optimization purposes, keep the number of VLFs to less than 50.

If you want to find out how the number of VLFs affects the performance of SQL Server, see “KimberlyL. Tripp’s Blog, immerse yourself in sql server,” at http://www.sqlskills.com/blogs/kimberly/.

2. 将日志的增长大小设置成一个合理的值,可以优化性能. 微软技术专家建议设置100M-300M. 我先设置成100M试试.

Note that the size set for growth_increment determines how many VLFs there will be. If the size of the increments is small, you will have a large number of VLFs. It is better to have a large value for the growth_increment and to set the size for the log file to a value close to the final value that you envisage. The default growth_increment for the log file is 10 percent.