公开(公告)号：US20110295801A1

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

申请号：US13207763

申请日：2011-08-11

申请人： Karl DIAS ,  Leonidas GALANIS ,  Jonathan KLEIN ,  Venkateshwaran VENKATARAMANI ,  Yujun WANG

发明人： Karl DIAS ,  Leonidas GALANIS ,  Jonathan KLEIN ,  Venkateshwaran VENKATARAMANI ,  Yujun WANG

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.

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

公开(公告)号：US20090248621A1

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

申请号：US12060117

申请日：2008-03-31

申请人： Benoit DAGEVILLE ,  Venkateshwaran VENKATARAMANI

发明人： Benoit DAGEVILLE ,  Venkateshwaran VENKATARAMANI

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