FILTERING WORKLOAD FOR DATABASE REPLAY
    15.
    发明申请
    FILTERING WORKLOAD FOR DATABASE REPLAY 有权
    过滤工作量用于数据库重置

    公开(公告)号:US20110295801A1

    公开(公告)日:2011-12-01

    申请号:US13207763

    申请日:2011-08-11

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30286

    摘要: A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.

    摘要翻译: 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面,为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载,生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此,测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中,则上述技术允许数据库管理员确定生产数据库系统将如何展示。

    METHOD AND MECHANISM FOR OUT-OF-THE-BOX REAL-TIME SQL MONITORING
    17.
    发明申请
    METHOD AND MECHANISM FOR OUT-OF-THE-BOX REAL-TIME SQL MONITORING 有权
    用于实时实时SQL监控的方法和机制

    公开(公告)号:US20090248621A1

    公开(公告)日:2009-10-01

    申请号:US12060117

    申请日:2008-03-31

    IPC分类号: G06F7/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)。 该方法支持在查询语句的执行计划的每个步骤以及为满足近实时查询监视解决方案的要求而处理的每个行中监视的各种性能统计信息。 这样的统计数据包括定时信息加上一些杂项统计数据,如处理的行数,使用的内存量,溢出到磁盘的数据量等。

    Database workload replay remapping infrastructure
    18.
    发明申请
    Database workload replay remapping infrastructure 审中-公开
    数据库工作负载重播重新映射基础设施

    公开(公告)号:US20080098003A1

    公开(公告)日:2008-04-24

    申请号:US11800240

    申请日:2007-05-03

    IPC分类号: G06F17/30

    CPC分类号: G06F16/217

    摘要: A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.

    摘要翻译: 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面,为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载,生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此,测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中,则上述技术允许数据库管理员确定生产数据库系统将如何展示。

    Database workload capture and replay architecture
    19.
    发明申请
    Database workload capture and replay architecture 有权
    数据库工作负载捕获和重播架构

    公开(公告)号:US20080097995A1

    公开(公告)日:2008-04-24

    申请号:US11800122

    申请日:2007-05-03

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30377

    摘要: A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.

    摘要翻译: 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面,为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载,生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此,测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中,则上述技术允许数据库管理员确定生产数据库系统将如何展示。

    Method and mechanism for out-of-the-box real-time SQL monitoring
    20.
    发明授权
    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)。 该方法支持在查询语句的执行计划的每个步骤以及为满足近实时查询监视解决方案的要求而处理的每个行中监视的各种性能统计信息。 这样的统计数据包括定时信息加上一些杂项统计数据,如处理的行数,使用的内存量,溢出到磁盘的数据量等。