通过在数据计数器上设置过滤器和条件,很容易设置提醒。
It is easy to set up alerts by setting filters and qualifications on a data counter.
清单6.打开性能计数器和格式化捕捉到的数据。
Listing 6. Turning on the performance counter and formatting the captured data.
信息是从入站事件所携带的数据中提取的,并包含在指标、计数器和秒表中,这些信息表示监视上下文所收集的业务度量。
The information is extracted from the data carried by inbound events, and is held in metrics, counters, and stopwatches, which represent the business measures that a monitoring context collects.
所有检索操作均会返回包含修订计数器的数据项。
All retrieve operations return data items that include the revision counter.
由于关系数据和索引存储在表空间内不同的存储对象中,因此它们具有不同的读和写计数器。
Since relational data and indexes are stored in separate storage objects within a table space, they have separate read and write counters.
查询是计数器的集合,它是用自定义代码创建的,用于管理性能数据的集合。
A query is a collection of counters, created in your custom code, to manage the collection of performance data.
通常情况下没有进行复位而收集的数据不是很有用,因为计数器的时间跨度较长,包括随着负荷起伏跌宕截然不同的工作负载。
Typically the data collected without a reset is not very useful because the counters span a longer period of time, including drastically different workloads along peaks and valleys in load.
查询用在PDH函数调用中更新它管理的计数器,因而获取性能数据。
Queries are used within PDH function calls to update the counters it manages, thereby obtaining performance data.
在清单6中,从根据计数器作为初始步骤的动态sql快照数据中,您可以从总体成本、频率和每次调用成本角度列出最优sql语句。
From dynamic SQL snapshot data as the initial step based on the counters in Listing 6, you should be able to list out the top SQL statements in terms of total cost, frequency, and cost per invocation.
麻省理工学院的大气科学系教授罗纳德·普林解释了显示牌上的数字:“计数器上的数字来源于全球的测量数据。
Ronald Prinn, professor of atmospheric science at MIT, explained the data behind the sign: "The number on the counter is based on global measurements.
数据包在跳频序列中的位置由主设备中的一个27位计数器决定。
The position in the sequence is determined by a 27-bit counter in the master device.
基于每台服务器中的性能数据,使用PMI的监控工具有助于进行工作负载管理、容量规划并通过检测相关PM i计数器的值来生成警告。
Based on the performance data in each server, a monitoring tool using PMI can help with workload management, capacity planning, and generating alerts by checking the values of related PMI counters.
短期历史数据的性能计数器可以自动聚合在一起并用于长期趋势分析。
Performance counters of short-term history are automatically aggregated and can be used for long-term trend analysis.
性能跟踪格式化器是一个解析选项,它将包含性能计数器数据的转储文件格式化为可读文本(请参见清单6)。
The performance trace formatter is a parsing option that formats a dump file containing performance counter data into readable text (see Listing 6).
清单1给出一个简单的UDF,它处理对象的基线数据不存在或者发生计数器翻转的情况(这种情况不太可能出现,但是能够处理)。
Listing 1 shows a simple UDF for handling cases where baseline data for an object does not exist, or where counter rollover has occurred (an unlikely scenario, but it is handled).
对于计数器,为3行历史数据中最后一行和第一行值的差。
For a counter, the difference in the value between the last and the first history row of the 3 rows.
使用udi计数器跟踪数据变化。
选择您想要在其中比较计数器的数据库。
您可以使用操作系统计数器来帮助理解数据库引擎外部的组件如何影响您的数据服务器。
You can use operating system counters to help you understand how components outside of the database engine affect your data server.
向数据库添加触发器,以便对该表中的记录的每个更新都会导致修订计数器递增。
We add a trigger to database so that every update to a record in the table increments the revision counter.
一旦终止或重新启动实例或数据库,计数器便会复位。
Counters are reset when you stop and restart an instance or database.
请注意,此实现在更新时要求使用者提供正确的修订计数器;进行纠正的责任分散到数据库、提供者和使用者三者身上。
Note how this implementation requires the consumer to provide an accurate revision counter when it is being updated; responsibility for correctness is spread across database, provider, and consumer.
如果基线不存在,计数器值相对于数据库激活时。
If no baseline exists, counters are relative to database activation.
更新操作实现必须对数据库记录进行限定的更新操作,如“如果修订计数器等于…则更新记录…”。
The update operation implementation must make a qualified update to the database record such as, "update record.".. where the the revision counter equals...
很多数据源包括的数据都是和存储信息无关的,例如计数器,用来分类数据的临时助手以及用户接口的多种语言文本。
Many data sources include data that is irrelevant for understanding stored information, such as counters, temporary helper tables used to sort data, and multilingual text for the user interface.
您将发现,与用于关系数据和索引的已有的计数器相对应,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.
对于不报告计数器值的任何输出列(例如基于状态的输出),包装器直接返回底层监控表函数产生的数据,不做修改。
Any output columns that do not report counter values (for example, state based output) are returned directly from the underlying monitoring table function with no modification by the wrapper.
教训就是:如果您不能确定一个特定的计数器数据什么样的数据,就请高亮显示该计数器,然后选择EXPLAIN来显示描述(图6)。
The lesson is this: if you're not sure what data a specific counter collects, highlight the counter and select EXPLAIN to display a description (Figure 6).
日志记录功能可用于收集性能数据,指定用户要监视的计数器,并且把数据输出到文件中。
A logging function is available to collect performance data, allowing the user to specify the counters to be monitored and output the data to a file.
下表中列出了捕捉udi计数器的系统目录中的新列,以及在运行统计数据过程中捕捉的额外信息。
The following tables list the new columns in system catalogs that capture UDI counters, and additional information captured during statistics run.
应用推荐