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

来源：互联网发布：淘宝虎扑足球鞋店铺编辑：程序博客网时间：2024/06/04 18:31

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.