The buffer pool hit ratio is now showing excellent results.
现在的缓冲池命中率就显示了较好的结果。
The buffer pool hit ratio = (1 - (1838 + 50) / (269482 + 82)) * 100% = 99.29%
缓冲池命中率 = (1- (1838 +50) / (269482 + 82)) * 100% = 99.29%
The buffer pool hit ratio = (1- (273548 + 52) / (183925 + 82)) * 100% = 48.69%
缓冲池命中率 = (1- (273548 +52) / (183925 + 82)) * 100% = 48.69%
A desirable goal for your buffer pool hit ratio is 80% or higher for data, and 90% or higher for index.
您的缓冲池命中率的理想目标是数据80%或更高，索引90%或更高。
With the buffer pool size of 250 pages, the application test run experienced very poor buffer pool hit ratio of 48.69%.
通过250个页面的缓冲池大小，应用程序测试运行呈现了48.69%的糟糕的缓冲池命中率。
If necessary, you can separate data and index into two different buffer pools to help ensure a good index buffer pool hit ratio.
如果必要，可以将数据和索引分隔到两个不同的缓冲池中，以帮助确保一个良好的索引缓冲池命中率。
You can use the snapshot report to derive information such as the buffer pool hit ratio, amount of sort heap overflows, and the system workload.
您可以使用快照来获得诸如缓冲池命中率、排序堆溢出的次数以及系统工作负载之类的信息。
Problem queries: These queries return only rows that exceed thresholds for important performance counters, for example, rows with buffer pool hit ratio lower than 90%.
问题查询：这些查询只返回超过重要性能计数器阈值的行，例如缓冲池命中率不到90%的行。
When multiple buffer pools are in use, the buffer pool snapshot data can be used to calculate the buffer pool hit ratio of each pool to indicate the effectiveness of each buffer pool.
当多个缓冲池同时在用时，缓冲池快照数据可用于计算每个缓冲池的命中率，来表示每个缓冲池的有效性。
For example, you can define a threshold alert to be triggered if your Buffer Pool Hit ratio drops to below 60% for a warning level or 55% for a problem level.
例如，您可以定义当Buffer Pool Hit ratio下降到低于60%时触发一个警告级阈值提醒，或者低于55%时触发一个问题级阈值提醒。
As a result, compression allows more data to be in memory than without compression, which increases the buffer-pool hit ratio and makes higher utilization of the available memory.
因此，相比不压缩，压缩能让内存存储更多的数据，进而提高了缓冲池命中率和可用内存的利用率。
As a result, compression allows more data to be in memory than without compression, which increases the buffer-pool hit ratio and makes higher utilization of the available memory.
因此，相比不压缩，压缩能让内存存储更多的数据，进而提高了缓冲池命中率和可用内存的利用率。
应用推荐