我们将讨论其他的性能监控和调优技术、Design Advisor的使用、活动监控器、表快照函数和其他工具。
We will discuss other performance monitoring and tuning techniques, and the use of the Design Advisor, the activity monitor, table snapshot functions, and other tools.
快照监控器允许您捕获特定时间内数据库活动的状态,而事件监控器只在特定数据库事件发生时记录数据。
The snapshot monitor enables you to capture a picture of the state of the database activity at a specific moment in time, while event monitors log data only as specified database events occur.
监控器数据收集应该包含一个时间框架,您期望在这段时间内发生普通数据库活动(例如,每个工作日的9 a .m .到5 p. m.)。
Your collection of monitor data should cover a time frame in which you would expect normal database activity (for example, between 9 a.m. and 5 p.m. during a workday).
在IBMDB 2 9.7中,活动和统计事件监控器都具有DETAILS_XML监控器元素,该元素存储包含大量活动和系统指标的XML文档。
In IBM DB2 9.7, both the activity and statistics event monitors have a DETAILS_XML monitor element that stores an XML document which contains a wealth of activity and system metrics.
多数监控器的计数器是累计的,反映从您的会话(您从中发布db 2命令)中最后一次快照监控器复位起的具体活动的总数。
Most of the monitor counters are cumulative, reflecting the total count of a particular activity since the last snapshot monitor reset within your session from which you are issuing your db2 command.
多数监控器的计数器是累计的,反映从您的会话(您从中发布db 2命令)中最后一次快照监控器复位起的具体活动的总数。
Most of the monitor counters are cumulative, reflecting the total count of a particular activity since the last snapshot monitor reset within your session from which you are issuing your db2 command.
应用推荐