问题查询:这些查询只返回超过重要性能计数器阈值的行,例如缓冲池命中率不到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%.
您将发现,与用于关系数据和索引的已有的计数器相对应,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.
池大小(黄色)是池中线程数量的平均值,而活动计数(红色)是当前活动线程的数量。
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.
应用推荐