-
公开(公告)号:US20050216490A1
公开(公告)日:2005-09-29
申请号:US10916695
申请日:2004-08-11
申请人: Karl Dias , Graham Wood , Shivani Gupta , Sushil Kumar , Mark Ramacher , Uri Shaft , Leng Leng Tan , Venkateshwaran Venkataramani
发明人: Karl Dias , Graham Wood , Shivani Gupta , Sushil Kumar , Mark Ramacher , Uri Shaft , Leng Leng Tan , Venkateshwaran Venkataramani
CPC分类号: G06F17/30289
摘要: One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.
摘要翻译: 为数据库提供一个或多个使用模型。 每个使用模型都包含一组用于分析数据库性能的规则。 确定一个或多个使用模型中的使用模型。 数据库信息是根据使用模式确定的。 然后基于与使用模型相关联的规则来分析数据库信息。 基于分析确定一个或多个性能问题。
-
公开(公告)号:US08024301B2
公开(公告)日:2011-09-20
申请号:US10916695
申请日:2004-08-11
申请人: Karl Dias , Graham S. Wood , Shivani Gupta , Sushil Kumar , Mark Ramacher , Uri Shaft , Leng Leng Tan , Venkateshwaran Venkataramani
发明人: Karl Dias , Graham S. Wood , Shivani Gupta , Sushil Kumar , Mark Ramacher , Uri Shaft , Leng Leng Tan , Venkateshwaran Venkataramani
IPC分类号: G06F7/00
CPC分类号: G06F17/30289
摘要: One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.
摘要翻译: 为数据库提供一个或多个使用模型。 每个使用模型都包含一组用于分析数据库性能的规则。 确定一个或多个使用模型中的使用模型。 数据库信息是根据使用模式确定的。 然后基于与使用模型相关联的规则来分析数据库信息。 基于分析确定一个或多个性能问题。
-
公开(公告)号:US20050055673A1
公开(公告)日:2005-03-10
申请号:US10775531
申请日:2004-02-09
申请人: Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham Wood , Juan Loaiza
发明人: Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham Wood , Juan Loaiza
IPC分类号: G06F9/44
CPC分类号: G06F17/30306 , G06F17/30371
摘要: Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.
摘要翻译: 提供了数据库中自我诊断性能问题的技术。 这些技术包括对数据库系统中的一个或多个性能问题进行分类。 然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。 量化值基于数据库系统中的操作性能来确定。 然后确定基于一个或多个量化值的性能问题。 产生性能问题的解决方案,并可以输出。
-
公开(公告)号:US07673291B2
公开(公告)日:2010-03-02
申请号:US10775531
申请日:2004-02-09
申请人: Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham S. Wood , Juan Loaiza
发明人: Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham S. Wood , Juan Loaiza
CPC分类号: G06F17/30306 , G06F17/30371
摘要: Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.
摘要翻译: 提供了数据库中自我诊断性能问题的技术。 这些技术包括对数据库系统中的一个或多个性能问题进行分类。 然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。 量化值基于数据库系统中的操作性能来确定。 然后确定基于一个或多个量化值的性能问题。 产生性能问题的解决方案,并可以输出。
-
公开(公告)号: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
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.
摘要翻译: 智能数据库基础设施,其中所有数据库组件的管理由数据库本身和数据库本身进行管理,通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置,纠正或警告恶劣条件,并提供有关如何提高整体系统性能的建议。
-
公开(公告)号: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.
摘要翻译: 智能数据库基础设施,其中所有数据库组件的管理由数据库本身和数据库本身进行管理,通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置,纠正或警告恶劣条件,并提供有关如何提高整体系统性能的建议。
-
公开(公告)号: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捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。
-
公开(公告)号:US07937623B2
公开(公告)日:2011-05-03
申请号:US12252056
申请日:2008-10-15
申请人: Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanya Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
发明人: Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanya Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
IPC分类号: G06F11/00
CPC分类号: G06F11/0778 , G06F11/0748 , G06F11/0781 , H04L41/0681 , H04L41/16
摘要: A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.
摘要翻译: 用于自动收集,存储,通信和分析一个或多个受监控系统的诊断数据的诊断系统。 诊断系统包括被配置用于收集,存储,通信和分析诊断数据的几个组件,用于在被监控系统中检测到的状况。 诊断系统能够有针对性地倾倒诊断数据,以便仅收集和存储与监视系统中检测到的病症相关的诊断数据。 这反过来使得能够进行第一次故障分析,从而减少解决在被监视系统中检测到的状况所需的时间。
-
公开(公告)号:US20090106278A1
公开(公告)日:2009-04-23
申请号:US12252056
申请日:2008-10-15
申请人: Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanyam Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
发明人: Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanyam Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
CPC分类号: G06F11/0778 , G06F11/0748 , G06F11/0781 , H04L41/0681 , H04L41/16
摘要: A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.
摘要翻译: 用于自动收集,存储,通信和分析一个或多个受监控系统的诊断数据的诊断系统。 诊断系统包括被配置用于收集,存储,通信和分析诊断数据的几个组件,用于在被监控系统中检测到的状况。 诊断系统能够有针对性地倾倒诊断数据,以便仅收集和存储与监视系统中检测到的病症相关的诊断数据。 这反过来使得能够进行第一次故障分析,从而减少解决在被监视系统中检测到的状况所需的时间。
-
-
-
-
-
-
-
-
-