-
公开(公告)号:US20090106601A1
公开(公告)日:2009-04-23
申请号:US12251661
申请日:2008-10-15
申请人: Gary Ngai , Jonathan Klein , Mark Ramacher , Benoit Dageville , Hailing Yu , Mike Feng , Yair Sarig , Marcus Fallen , John Beresniewicz
发明人: Gary Ngai , Jonathan Klein , Mark Ramacher , Benoit Dageville , Hailing Yu , Mike Feng , Yair Sarig , Marcus Fallen , John Beresniewicz
CPC分类号: G06F11/0778 , G06F11/0748 , G06F11/0781 , H04L41/0681 , H04L41/16
摘要: Techniques for systematically gathering, organizing, and storing diagnostic data related to multiple monitored systems (e.g., multiple instances of a product or multiple products). A centralized repository is provided that is organized in a hierarchical manner to facilitate proper organization of the diagnostic data related to multiple monitored systems. In one embodiment, a root directory comprising one or more subdirectories is provided for storing diagnostic data collected for each monitored system. Multiple root directories may be provided under a common base directory for storing diagnostic data corresponding to multiple monitored systems. This enables correlation of diagnostic data across multiple monitored systems.
摘要翻译: 用于系统地收集,组织和存储与多个被监视系统相关的诊断数据(例如,产品或多个产品的多个实例)的技术。 提供了一种以层次的方式组织的集中式存储库,以促进与多个监控系统相关的诊断数据的正确组织。 在一个实施例中,提供了包括一个或多个子目录的根目录,用于存储针对每个被监视系统收集的诊断数据。 可以在公共基本目录下提供多个根目录,用于存储对应于多个被监视系统的诊断数据。 这使得能够在多个被监视系统之间进行诊断数据的相关性。
-
公开(公告)号:US08135995B2
公开(公告)日:2012-03-13
申请号:US12251661
申请日:2008-10-15
申请人: Gary Ngai , Jonathan Klein , Mark Ramacher , Benoit Dageville , Hailing Yu , Mike Feng , Yair Sarig , Marcus Fallen , John Beresniewicz
发明人: Gary Ngai , Jonathan Klein , Mark Ramacher , Benoit Dageville , Hailing Yu , Mike Feng , Yair Sarig , Marcus Fallen , John Beresniewicz
IPC分类号: G06F11/00
CPC分类号: G06F11/0778 , G06F11/0748 , G06F11/0781 , H04L41/0681 , H04L41/16
摘要: Techniques for systematically gathering, organizing, and storing diagnostic data related to multiple monitored systems (e.g., multiple instances of a product or multiple products). A centralized repository is provided that is organized in a hierarchical manner to facilitate proper organization of the diagnostic data related to multiple monitored systems. In one embodiment, a root directory comprising one or more subdirectories is provided for storing diagnostic data collected for each monitored system. Multiple root directories may be provided under a common base directory for storing diagnostic data corresponding to multiple monitored systems. This enables correlation of diagnostic data across multiple monitored systems.
摘要翻译: 用于系统地收集,组织和存储与多个被监视系统相关的诊断数据(例如,产品或多个产品的多个实例)的技术。 提供了一种以层次的方式组织的集中式存储库,以促进与多个监控系统相关的诊断数据的正确组织。 在一个实施例中,提供了包括一个或多个子目录的根目录,用于存储针对每个被监视系统收集的诊断数据。 可以在公共基本目录下提供多个根目录,用于存储对应于多个被监视系统的诊断数据。 这使得能够在多个被监视系统之间进行诊断数据的相关性。
-
公开(公告)号: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.
摘要翻译: 用于自动收集,存储,通信和分析一个或多个受监控系统的诊断数据的诊断系统。 诊断系统包括被配置用于收集,存储,通信和分析诊断数据的几个组件,用于在被监控系统中检测到的状况。 诊断系统能够有针对性地倾倒诊断数据,以便仅收集和存储与监视系统中检测到的病症相关的诊断数据。 这反过来使得能够进行第一次故障分析,从而减少解决在被监视系统中检测到的状况所需的时间。
-
公开(公告)号:US08863091B2
公开(公告)日:2014-10-14
申请号:US12189080
申请日:2008-08-08
申请人: Benoit Dageville , Amirali S. Valiani , Hailing Yu , Gary Ngai
发明人: Benoit Dageville , Amirali S. Valiani , Hailing Yu , Gary Ngai
CPC分类号: G06F11/3636
摘要: A computer is programmed with multiple software programs to record structures including (a) unstructured information to denote a transition between portions of code, and (b) metadata related to one or more attributes of the information. In addition, the computer writes two additional types of structures: section type, and dump type. The section type structure has metadata to indicate a beginning and an end, to bracket a group of structures located therebetween. The dump type has a dump header and a dump body. The dump header includes a symbol to indicate it's of dump type. The dump body is a set of values of an object used by the software program(s) during execution by the computer. A group of structures, within a section type, may include structures of each of the trace record type, dump type and section type.
摘要翻译: 计算机被编程有多个软件程序以记录结构,包括(a)非结构化信息以表示代码部分之间的转换,以及(b)与信息的一个或多个属性有关的元数据。 此外,计算机还会写入两种附加类型的结构:段类型和转储类型。 部分类型结构具有表示开头和结尾的元数据,以支架位于其间的一组结构。 转储类型具有转储头和转储主体。 转储头包含一个表示它是转储类型的符号。 转储主体是由计算机执行期间由软件程序使用的对象的一组值。 一个区段类型中的一组结构可以包括每个跟踪记录类型,转储类型和段类型的结构。
-
公开(公告)号:US20090106741A1
公开(公告)日:2009-04-23
申请号:US12189080
申请日:2008-08-08
申请人: Benoit Dageville , Amirali S. Valiani , Hailing Yu , Gary Ngai
发明人: Benoit Dageville , Amirali S. Valiani , Hailing Yu , Gary Ngai
IPC分类号: G06F9/44
CPC分类号: G06F11/3636
摘要: A computer is programmed with multiple software programs to record structures including (a) unstructured information to denote a transition between portions of code, and (b) metadata related to one or more attributes of the information. In addition, the computer writes two additional types of structures: section type, and dump type. The section type structure has metadata to indicate a beginning and an end, to bracket a group of structures located therebetween. The dump type has a dump header and a dump body. The dump header includes a symbol to indicate it's of dump type. The dump body is a set of values of an object used by the software program(s) during execution by the computer. A group of structures, within a section type, may include structures of each of the trace record type, dump type and section type.
摘要翻译: 计算机被编程有多个软件程序以记录结构,包括(a)非结构化信息以表示代码部分之间的转换,以及(b)与信息的一个或多个属性有关的元数据。 此外,计算机还会写入两种附加类型的结构:段类型和转储类型。 部分类型结构具有表示开头和结尾的元数据,以支架位于其间的一组结构。 转储类型具有转储头和转储主体。 转储头包含一个表示它是转储类型的符号。 转储主体是由计算机执行期间由软件程序使用的对象的一组值。 一个区段类型中的一组结构可以包括每个跟踪记录类型,转储类型和段类型的结构。
-
公开(公告)号:US08688689B2
公开(公告)日:2014-04-01
申请号:US12827943
申请日:2010-06-30
申请人: Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人: Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
CPC分类号: G06F17/30463
摘要: Techniques are provided for automatically recommending alternative execution plans for a SQL statement. Information pertaining to one or more execution plans for a SQL statement can be retrieved from a set of plan sources. The one or more execution plans can include the current execution plan for the statement and one or more historical execution plans. Based on the retrieved information, the performance of the one or more execution plans can be compared to each other. Based on the comparison, a recommendation can be provided to a user indicating that a particular execution plan (e.g., a historical execution plan) should be used in place of the current execution plan to execute the SQL statement.
摘要翻译: 提供了技术来自动推荐SQL语句的替代执行计划。 有关SQL语句的一个或多个执行计划的信息可以从一组计划源中检索。 一个或多个执行计划可以包括该语句的当前执行计划和一个或多个历史执行计划。 基于检索到的信息,可以将一个或多个执行计划的性能彼此进行比较。 基于该比较,可以向用户提供指示使用特定执行计划(例如,历史执行计划)来代替执行SQL语句的当前执行计划的建议。
-
公开(公告)号:US09256642B2
公开(公告)日:2016-02-09
申请号:US12827926
申请日:2010-06-30
申请人: Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人: Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
CPC分类号: G06F17/30445
摘要: Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
摘要翻译: 自动推荐并行执行SQL语句的技术。 在一组实施例中,可以首先确定是否可以并行执行SQL语句。 此外,可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。 如果第一确定和第二确定是正的(即,可以并行执行语句并且并行执行以预定因子更快),则可以提供指示应该并行执行SQL语句的建议。 在一些实施例中,该建议可以包括指定从并行执行获得的性能改进程度的报告,并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。
-
公开(公告)号:US20120005189A1
公开(公告)日:2012-01-05
申请号:US12827943
申请日:2010-06-30
申请人: Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人: Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号: G06F17/30
CPC分类号: G06F17/30463
摘要: Techniques for automatically recommending alternative execution plans for a SQL statement. In one set of embodiments, information pertaining to one or more execution plans for a SQL statement can be retrieved from a set of plan sources. The one or more execution plans can include the current execution plan for the statement and one or more historical execution plans. Based on the retrieved information, the performance of the one or more execution plans can be compared to each other. Based on the comparison, a recommendation can be provided to a user indicating that a particular execution plan (e.g., a historical execution plan) should be used in place of the current execution plan to execute the SQL statement.
摘要翻译: 自动推荐SQL语句的替代执行计划的技术。 在一组实施例中,可以从一组计划源检索关于SQL语句的一个或多个执行计划的信息。 一个或多个执行计划可以包括该语句的当前执行计划和一个或多个历史执行计划。 基于检索到的信息,可以将一个或多个执行计划的性能彼此进行比较。 基于该比较,可以向用户提供指示使用特定执行计划(例如,历史执行计划)来代替执行SQL语句的当前执行计划的建议。
-
公开(公告)号:US20120005188A1
公开(公告)日:2012-01-05
申请号:US12827926
申请日:2010-06-30
申请人: Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人: Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号: G06F17/30
CPC分类号: G06F17/30445
摘要: Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
摘要翻译: 自动推荐并行执行SQL语句的技术。 在一组实施例中,可以首先确定是否可以并行执行SQL语句。 此外,可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。 如果第一确定和第二确定是正的(即,可以并行执行语句并且并行执行以预定因子更快),则可以提供指示应该并行执行SQL语句的建议。 在一些实施例中,该建议可以包括指定从并行执行获得的性能改进程度的报告,并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。
-
-
-
-
-
-
-
-
-