公开(公告)号：US08380665B2

公开(公告)日：2013-02-19

申请号：US13076313

申请日：2011-03-30

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/00

CPC分类号： G06F11/3688

摘要： An application workload capture and replay system with a transactionally consistent application workload replay feature is provided. More particularly, the feature includes capture-phase components for capturing and recording a real application workload submitted to a production web application system and includes replay-phase components for replaying the captured application workload against a test web application system in a transactionally consistent manner. The feature provides guarantees about the order of database transactions that are caused when the workload is replayed such that there is a consistency between the replay-phase order of the database transactions and the order of those transactions that occurred when the workload was captured. These consistency guarantees facilitate a faithful reproduction of database changes observed in the production web application system in the test web application system using a captured real application workload. Significantly, this faithful reproduction may be accomplished without having to create a synthetic application workload that approximates or emulates the transactional behavior of the real application workload. Instead, a real application workload may be used as or substantially as it is captured.

摘要翻译： 提供了具有事务一致的应用程序工作负载重放功能的应用程序工作负载捕获和重放系统。 更具体地，该特征包括用于捕获和记录提交到生产web应用系统的真实应用工作负载的捕获相组件，并且包括用于以事务一致的方式针对测试web应用系统重放所捕获的应用工作负载的重放阶段组件。 该功能提供了关于在重放工作负载时引起的数据库事务的顺序的保证，使得数据库事务的重放阶段顺序与捕获工作负载时发生的那些事务的顺序之间存在一致性。 这些一致性保证有助于在测试Web应用系统中使用捕获的实际应用程序工作负载忠实地再现在生产Web应用系统中观察到的数据库更改。 重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。 相反，真正的应用程序工作负载可以被使用或基本上被捕获。

公开(公告)号：US08380664B2

公开(公告)日：2013-02-19

申请号：US13034526

申请日：2011-02-24

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/00

CPC分类号： G06F17/30557

摘要： A database system providing transactionally consistent replay of application workloads. In a database system, a method providing transactionally consistent replay of application workloads comprises the steps of: during a replay phase in which a plurality of application requests that were previously submitted to an application server system during a capture phase are being replayed, receiving, at a database server, a database request to execute a database command against a database. The database request specifies an application request identifier that identifies a particular application request of the plurality of application requests. The particular application request caused the database command to be executed previously during the capture phase. In response to receiving the database request, determining, based on the application request identifier in the database request, whether to delay execution of the database command at least until a particular replay-phase database transaction has been committed.

摘要翻译： 数据库系统提供事务性一致的应用程序工作负载重播。 在数据库系统中，提供事务性地一致地重放应用工作负载的方法包括以下步骤：在重放阶段，其中在捕获阶段期间先前提交给应用服务器系统的多个应用请求正在被重播， 数据库服务器，针对数据库执行数据库命令的数据库请求。 数据库请求指定标识多个应用请求的特定应用请求的应用请求标识符。 特定的应用程序请求导致数据库命令在捕获阶段之前执行。 响应于接收到数据库请求，基于数据库请求中的应用请求标识确定是否延迟数据库命令的执行至少直到特定的重放阶段数据库事务被提交。

公开(公告)号：US08326816B2

公开(公告)日：2012-12-04

申请号：US12775322

申请日：2010-05-06

申请人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/303

摘要： A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.

摘要翻译： 提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。 捕获过程捕获生产系统执行的数据库命令的工作负载。 捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。 捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。 处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。 测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。

公开(公告)号：US08296104B2

公开(公告)日：2012-10-23

申请号：US12251648

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G06F11/00 ,  G06F11/30

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： An infrastructure is provided for gathering diagnostic data that is relevant to an error or other conditions detected in a monitored system. A diagnosability framework is provided that automates the gathering of relevant diagnostic data upon occurrence of the condition in the monitored system. In one embodiment, context data is determined for the condition detected in the monitored system. A rule-based engine is provided that is configured to automatically determine one or more actions to be performed for the condition detected in the monitored system based on the determined context data. The actions may include performing tasks that gather diagnostic data that is relevant to the detected condition, store the gathered diagnostic data in a repository, recommend one or more diagnostic actions to a user, and other diagnostic related actions.

摘要翻译： 提供了一个基础设施，用于收集与受监视系统中检测到的错误或其他条件相关的诊断数据。 提供了一种诊断框架，可在受监控系统中发生状况时自动收集相关诊断数据。 在一个实施例中，为在所监视的系统中检测到的状况确定上下文数据。 提供了一种基于规则的引擎，其被配置为基于所确定的上下文数据来自动确定要在被监视系统中检测到的条件执行的一个或多个动作。 动作可以包括执行收集与检测到的条件相关的诊断数据的任务，将收集的诊断数据存储在存储库中，向用户推荐一个或多个诊断动作以及其他诊断相关的动作。

公开(公告)号：US08255182B2

公开(公告)日：2012-08-28

申请号：US12251667

申请日：2008-10-15

申请人： Yair Sarig ,  Benoit Dageville ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  Karl Dias ,  Mark Ramacher ,  Gary Ngai

发明人： Yair Sarig ,  Benoit Dageville ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  Karl Dias ,  Mark Ramacher ,  Gary Ngai

IPC分类号： G06F11/30 ,  G06F19/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for controlling collection of diagnostic data in a monitored system. A set of flood control rules are configured for the monitored system for controlling the gathering of diagnostic data in the monitored system. The set of flood control rules may include one or more default flood control rules. The set of flood control rules are user-configurable enabling the user of the monitored system to set policies for dynamically controlling gathering of diagnostic data for the monitored system. In one embodiment, diagnostic data gathering is controlled based upon a number of previous occurrences of a condition in some predefined or user-configured time frame that triggers diagnostic data gathering and/or a number of previous executions of an action performed in some predefined or user-configured time frame responsive to the condition in the monitored system.

摘要翻译： 用于控制监控系统中诊断数据收集的技术。 为监控系统配置了一组防洪规则，用于控制监控系统中诊断数据的收集。 防洪规则集可以包括一个或多个默认防洪规则。 一组防洪规则是用户可配置的，使受监控系统的用户能够设置动态控制监控系统诊断数据采集的策略。 在一个实施例中，诊断数据收集是基于在某些预定义或用户配置的时间帧中的先前事件的数量来控制的，该时间帧触发诊断数据收集和/或在某些预定义或用户中执行的动作的先前执行的数量 响应于受监视系统中的状况而配置的时间帧。

公开(公告)号：US08161323B2

公开(公告)日：2012-04-17

申请号：US12252128

申请日：2008-10-15

申请人： Balasubrahmanya Kuchibhotla ,  Jonathan Klein ,  Karl Dias ,  Uri Shaft

发明人： Balasubrahmanya Kuchibhotla ,  Jonathan Klein ,  Karl Dias ,  Uri Shaft

IPC分类号： G06F11/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for proactively and reactively running diagnostic functions. These diagnostic functions help to improve diagnostics of conditions detected in a monitored system and to limit/quarantine the damages caused by the detected conditions. In one embodiment, a health monitor infrastructure is provided that is configured to perform one or more health checks in a monitored system for diagnosing and/or gathering information related to the system. The one or more health checks may be invoked pro-actively on a scheduled basis, reactively in response to a condition detected in the system, or may even be invoked manually by a user such as a system administrator.

摘要翻译： 主动和反应地运行诊断功能的技术。 这些诊断功能有助于改善在受监控系统中检测到的条件的诊断，并限制/检疫由检测到的条件引起的损害。 在一个实施例中，提供健康监视器基础设施，其被配置为在受监视的系统中执行一个或多个健康检查以诊断和/或收集与该系统有关的信息。 响应于在系统中检测到的状况，或者甚至可以由诸如系统管理员的用户手动地调用一个或多个健康检查，可以在调度的基础上主动地调用。

公开(公告)号：US08135988B2

公开(公告)日：2012-03-13

申请号：US12251711

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G06F11/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for non-intrusive performance of diagnostic actions including actions that result in gathering of diagnostic data in response to a condition detected in a monitored system. In one embodiment, the diagnostic actions are performed asynchronously by processes or threads that are different from the failing process or thread that receives or detects the condition that triggers the diagnostic actions such that the failing process or thread can continue processing without being affected by the executions of the diagnostic actions. Multiple asynchronous processes or threads that are different from the failing process or thread may be spawned to perform multiple diagnostic actions in parallel. The asynchronous processes or threads may be monitored to ensure that they do not adversely impact the monitored system.

摘要翻译： 用于非侵入式执行诊断动作的技术，包括导致响应于在受监视系统中检测到的状况而收集诊断数据的动作。 在一个实施例中，诊断动作由与接收或检测触发诊断动作的状况不同的进程或线程不同的进程或线程异步执行，使得故障进程或线程可以继续处理而不受执行的影响 的诊断动作。 可能会产生与故障进程或线程不同的多个异步进程或线程，以并行执行多个诊断操作。 可以监视异步进程或线程，以确保它们不会对受监视的系统产生不利影响。

公开(公告)号：US08095514B2

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

申请号：US12365827

申请日：2009-02-04

申请人： John Beresniewicz ,  Jonathan Helfman ,  Hsiao-Te Su ,  Nancy Chen ,  Karl Dias ,  Graham Wood

发明人： John Beresniewicz ,  Jonathan Helfman ,  Hsiao-Te Su ,  Nancy Chen ,  Karl Dias ,  Graham Wood

IPC分类号： G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30592 ,  G06F17/30961 ,  Y10S707/99945

摘要： Particular embodiments generally relate to displaying database time using a treemap. A set of database time values is determined for a set of dimensions. The database time values measure performance of one or more databases by the time the database takes to respond to a request. The set of database time values is correlated to a set of cells in the treemap. A size of the cell is determined based on the database time value associated with it. For example, the database time value is correlated to an area of the cell. A layout of the set of cells is determined and the treemap is displayed using the layout. For example, the largest values of database time may be shown with the largest sized cells. This makes it easier for an administrator to review and analyze the database performance across multiple dimensions and determine problem areas affecting the performance of the one or more databases.

摘要翻译： 具体实施方案一般涉及使用树形图显示数据库时间。 为一组维度确定一组数据库时间值。 数据库时间值衡量数据库响应请求时所需的一个或多个数据库的性能。 数据库时间值集合与树形图中的一组单元格相关联。 基于与其相关联的数据库时间值来确定单元的大小。 例如，数据库时间值与单元的区域相关。 确定一组单元格的布局，并使用布局显示树状图。 例如，数据库时间的最大值可以用最大尺寸的单元显示。 这使管理员更容易查看和分析多个维度的数据库性能，并确定影响一个或多个数据库性能的问题区域。

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

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

公开(公告)号：US20110276550A1

公开(公告)日：2011-11-10

申请号：US12775322

申请日：2010-05-06

申请人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/303

摘要： A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.

摘要翻译： 提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。 捕获过程捕获生产系统执行的数据库命令的工作负载。 捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。 捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。 处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。 测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。