Method and mechanism for out-of-the-box real-time SQL monitoring
    25.
    发明授权
    Method and mechanism for out-of-the-box real-time SQL monitoring 有权
    开箱即用的实时SQL监控的方法和机制

    公开(公告)号:US08577871B2

    公开(公告)日:2013-11-05

    申请号:US12060117

    申请日:2008-03-31

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30306

    摘要: Methods, systems, and computer program products for monitoring database queries and executions is disclosed. The query syntax may conform to the structured query language (SQL). The approach supports various performance statistics to be monitored at each step of the query statement's execution plan and for each row processed in order to meet requirements of a near real-time query monitoring solution. Such statistics include timing information plus some miscellaneous statistics like the number of rows processed, the amount of memory used, the amount of data spilled to disk, etc.

    摘要翻译: 公开了用于监视数据库查询和执行的方法,系统和计算机程序产品。 查询语法可以符合结构化查询语言(SQL)。 该方法支持在查询语句的执行计划的每个步骤以及为满足近实时查询监视解决方案的要求而处理的每个行中监视的各种性能统计信息。 这样的统计数据包括定时信息加上一些杂项统计数据,如处理的行数,使用的内存量,溢出到磁盘的数据量等。