公开(公告)号：US08229953B2

公开(公告)日：2012-07-24

申请号：US12731743

申请日：2010-03-25

申请人： Venkata Ramana Kapuram ,  Rajiv K. Maheshwari ,  Richard Sarwal

发明人： Venkata Ramana Kapuram ,  Rajiv K. Maheshwari ,  Richard Sarwal

IPC分类号： G06F17/30 ,  G06F3/048

CPC分类号： G06Q10/06

摘要： Techniques for improved metric correlation and analysis include, during a modeling phase, a user familiar with the types of system components deployed in an enterprise network and the metrics available for those types of system components specifying dependencies between metrics in a metric dependency model. During a binding phase, the metric dependency model is provided to a modified enterprise management (MEM) system which binds the model to particular enterprise system environment. During a metric correlation and analysis phase, the MEM system provides a user-interface through which a user visually compares metric data for metrics collected from system components deployed in an enterprise system environment bound to the model. The improved metric correlation analysis techniques allow users to more easily identify whether degradation in the performance of one metric is caused by performance degradation of underlying information technology system components as measured by related metrics specified in the metric dependency model.

摘要翻译： 用于改进的度量相关性和分析的技术包括在建模阶段期间，熟悉部署在企业网络中的系统组件的类型的用户以及可用于指定度量依赖关系模型中的度量之间的依赖关系的那些类型的系统组件的度量。 在绑定阶段期间，将度量依赖关系模型提供给将模型绑定到特定企业系统环境的修改后的企业管理（MEM）系统。 在度量相关和分析阶段期间，MEM系统提供用户界面，用户通过该界面可视地比较从部署在与模型绑定的企业系统环境中的系统组件收集的度量的度量数据。 改进的度量相关分析技术允许用户更容易地识别一个度量的性能的劣化是否由基础信息技术系统组件的性能下降引起，如由度量依赖模型中指定的相关度量所测量的。

公开(公告)号：US20110238687A1

公开(公告)日：2011-09-29

申请号：US12731743

申请日：2010-03-25

申请人： Venkata Ramana Karpuram ,  Rajiv K. Maheshwari ,  Richard Sarwal

发明人： Venkata Ramana Karpuram ,  Rajiv K. Maheshwari ,  Richard Sarwal

IPC分类号： G06F3/048 ,  G06F17/30

CPC分类号： G06Q10/06

摘要： Techniques for improved metric correlation and analysis include, during a modeling phase, a user familiar with the types of system components deployed in an enterprise network and the metrics available for those types of system components specifying dependencies between metrics in a metric dependency model. During a binding phase, the metric dependency model is provided to a modified enterprise management (MEM) system which binds the model to particular enterprise system environment. During a metric correlation and analysis phase, the MEM system provides a user-interface through which a user visually compares metric data for metrics collected from system components deployed in an enterprise system environment bound to the model. The improved metric correlation analysis techniques allow users to more easily identify whether degradation in the performance of one metric is caused by performance degradation of underlying information technology system components as measured by related metrics specified in the metric dependency model.

摘要翻译： 用于改进的度量相关性和分析的技术包括在建模阶段期间，熟悉部署在企业网络中的系统组件的类型的用户以及可用于指定度量依赖关系模型中的度量之间的依赖关系的那些类型的系统组件的度量。 在绑定阶段期间，将度量依赖关系模型提供给将模型绑定到特定企业系统环境的修改后的企业管理（MEM）系统。 在度量相关和分析阶段期间，MEM系统提供用户界面，用户通过该界面可视地比较从部署在与模型绑定的企业系统环境中的系统组件收集的度量的度量数据。 改进的度量相关分析技术允许用户更容易地识别一个度量的性能的劣化是否由基础信息技术系统组件的性能下降引起，如由度量依赖模型中指定的相关度量所测量的。

公开(公告)号：US07984015B2

公开(公告)日：2011-07-19

申请号：US11800122

申请日：2007-05-03

申请人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang ,  Richard Sarwal ,  Leng Tan ,  Graham Wood ,  Benoit Dageville ,  Chao Liang ,  Sanjay Kaluskar

发明人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang ,  Richard Sarwal ,  Leng Tan ,  Graham Wood ,  Benoit Dageville ,  Chao Liang ,  Sanjay Kaluskar

IPC分类号： G06F7/00 ,  G06F17/00

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.

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

公开(公告)号：US20080097995A1

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

申请号：US11800122

申请日：2007-05-03

申请人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang ,  Richard Sarwal ,  Leng Tan ,  Graham Wood ,  Benoit Dageville ,  Chao Liang ,  Sanjay Kaluskar

发明人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang ,  Richard Sarwal ,  Leng Tan ,  Graham Wood ,  Benoit Dageville ,  Chao Liang ,  Sanjay Kaluskar

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.

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

公开(公告)号：US07774312B2

公开(公告)日：2010-08-10

申请号：US10934771

申请日：2004-09-03

申请人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham S. Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

发明人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham S. Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.

摘要翻译： 自管理工作负载存储库（AWR）基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。 根据计划，AWR自动运行以收集有关数据库系统操作的数据，并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用，以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 统计数据捕获的频率和保存数据的时间长短都是可调的。 也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

公开(公告)号：US20050086246A1

公开(公告)日：2005-04-21

申请号：US10934345

申请日：2004-09-03

申请人： Graham Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

发明人： Graham Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.

摘要翻译： 定义和存储性能基线的系统和方法。 基线可以被定义为一对快照，每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。 本发明允许自动或手动地指定在一段时间内收集的统计数据，并将其用于比较。 可以使用基线来手动或自动与当前系统性能进行比较，比较差异差值和设置阈值以监视当前系统性能。

公开(公告)号：US07664798B2

公开(公告)日：2010-02-16

申请号：US10934345

申请日：2004-09-03

申请人： Graham Stephen Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

发明人： Graham Stephen Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

IPC分类号： G07F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.

摘要翻译： 定义和存储性能基线的系统和方法。 基线可以被定义为一对快照，每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。 本发明允许自动或手动地指定在一段时间内收集的统计数据，并将其用于比较。 可以使用基线来手动或自动与当前系统性能进行比较，比较差异差值和设置阈值以监视当前系统性能。

公开(公告)号：US07526508B2

公开(公告)日：2009-04-28

申请号：US10934076

申请日：2004-09-03

申请人： Leng Leng Tan ,  Gianfranco Putzolu ,  Richard Sarwal ,  Alex Tsukerman ,  Gary C. Ngai ,  Graham Stephen Wood ,  Karl Dias ,  Mark Ramacher ,  Benoit Dageville ,  Mohamed Ziauddin ,  Tirthankar Lahiri ,  Sujatha Muthulingam ,  Vishwanath Karra ,  Francisco Sanchez ,  Hsiao-Te Su ,  Wanli Yang ,  Vasudha Krishnaswamy ,  Sushil Kumar

发明人： Leng Leng Tan ,  Gianfranco Putzolu ,  Richard Sarwal ,  Alex Tsukerman ,  Gary C. Ngai ,  Graham Stephen Wood ,  Karl Dias ,  Mark Ramacher ,  Benoit Dageville ,  Mohamed Ziauddin ,  Tirthankar Lahiri ,  Sujatha Muthulingam ,  Vishwanath Karra ,  Francisco Sanchez ,  Hsiao-Te Su ,  Wanli Yang ,  Vasudha Krishnaswamy ,  Sushil Kumar

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

摘要翻译： 智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

公开(公告)号：US20050086263A1

公开(公告)日：2005-04-21

申请号：US10934771

申请日：2004-09-03

申请人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

发明人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

IPC分类号： G06F7/00

CPC分类号： G06F17/30306

摘要： A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.

摘要翻译： 自管理工作负载存储库（AWR）基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。 根据计划，AWR自动运行以收集有关数据库系统操作的数据，并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用，以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 统计数据捕获的频率和保存数据的时间长短都是可调的。 也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

公开(公告)号：US20050086195A1

公开(公告)日：2005-04-21

申请号：US10934076

申请日：2004-09-03

申请人： Leng Leng Tan ,  Gianfranco Putzolu ,  Richard Sarwal ,  Alex Tsukerman ,  Gary Ngai ,  Graham Wood ,  Karl Dias ,  Mark Ramacher ,  Benoit Dageville ,  Mohamed Ziauddin ,  Tirthankar Lahiri ,  Sujatha Muthulingam ,  Vishwanath Karra ,  Francisco Sanchez ,  Hsiao-Te Su ,  Wanli Yang ,  Vasudha Krishnaswamy ,  Sushil Kumar

发明人： Leng Leng Tan ,  Gianfranco Putzolu ,  Richard Sarwal ,  Alex Tsukerman ,  Gary Ngai ,  Graham Wood ,  Karl Dias ,  Mark Ramacher ,  Benoit Dageville ,  Mohamed Ziauddin ,  Tirthankar Lahiri ,  Sujatha Muthulingam ,  Vishwanath Karra ,  Francisco Sanchez ,  Hsiao-Te Su ,  Wanli Yang ,  Vasudha Krishnaswamy ,  Sushil Kumar

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

摘要翻译： 智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。