公开(公告)号：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.

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