有了从监控任务中收集的缓冲池运行时统计数据，您就可以知道是否任何性能获益都可以从缓冲池调优实现。
With the buffer pool runtime statistics gathered from the monitoring tasks, you can see whether any performance gain can be achieved from buffer pool tuning.
您将发现，与用于关系数据和索引的已有的计数器相对应，DB 29为XML数据提供了新的缓冲池快照监视器元素。
You will find that DB2 9 offers new buffer pool snapshot monitor elements for XML data that match the existing counters for relational data and indexes.
问题查询：这些查询只返回超过重要性能计数器阈值的行，例如缓冲池命中率不到90%的行。
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%.
池大小(黄色)是池中线程数量的平均值，而活动计数(红色)是当前活动线程的数量。
The pool size (orange) is the average number of threads in the pool, and the active count (red) is the number of concurrently active threads.
池大小(黄色)是池中线程数量的平均值，而活动计数(红色)是当前活动线程的数量。
The pool size (orange) is the average number of threads in the pool, and the active count (red) is the number of concurrently active threads.
应用推荐