数据库性能优化
-
编辑 删除
Buffer Cache Hit Ratio Is Not Everything
Buffer Cache Hit Ratio Is Not Everything[@more@]For example, suppose two applications (A and B) return the same result set. Application Ahas a cache hit ratio of 99%, whereas Application B has a hit ratio of 60 %. Whichapplication has the best performance? On further investigation you notice that ApplicationA requires 100,000 logical reads and 1,000 physical reads, whereas Application B has 100logical reads and 40 physical reads. Which application is better tuned now? With theadditional informat
