-
公开(公告)号：US07401244B2
公开(公告)日：2008-07-15
申请号：US11559876
申请日：2006-11-14
CPC分类号： G06F9/4843 , G06Q10/04
摘要： An adaptive throttling system for minimizing the impact of non-production work on production work in a computer system is provided. The adaptive throttling system throttles production work and non-production work to optimize production. The adaptive throttling system allows system administrators to specify a quantified limit on the performance impact of non-production or utility work on production work. The throttling rate of the utility is then automatically determined by a supervisory agent, so that the utilities' impact is kept within the specified limit. The adaptive throttling system adapts dynamically to changes in workloads so as to ensure that valuable system resources are well utilized and utility work is not delayed unnecessarily.
摘要翻译： 提供了一种用于最小化非生产工作对计算机系统中的生产工作的影响的自适应节流系统。 自适应节流系统节约生产工作和非生产工作，优化生产。 自适应调节系统允许系统管理员指定非生产或公用事业工作对生产工作的绩效影响的量化限制。 公用事业的节流率由监督人员自动确定，使公用事业的影响力保持在规定的限度内。 自适应调节系统动态地适应工作负载的变化，以确保有价值的系统资源得到充分利用，并且公用事业工作不会不必要地延迟。
-
公开(公告)号：US20090019447A1
公开(公告)日：2009-01-15
申请号：US12136486
申请日：2008-06-10
IPC分类号： G06F9/46
CPC分类号： G06F9/4843 , G06Q10/04
摘要： An adaptive throttling system for minimizing the impact of non-production work on production work in a computer system is provided. The adaptive throttling system throttles production work and non-production work to optimize production. The adaptive throttling system allows system administrators to specify a quantified limit on the performance impact of non-production or utility work on production work. The throttling rate of the utility is then automatically determined by a supervisory agent, so that the utilities' impact is kept within the specified limit. The adaptive throttling system adapts dynamically to changes in workloads so as to ensure that valuable system resources are well utilized and utility work is not delayed unnecessarily.
摘要翻译： 提供了一种用于最小化非生产工作对计算机系统中的生产工作的影响的自适应节流系统。 自适应节流系统节约生产工作和非生产工作，优化生产。 自适应调节系统允许系统管理员指定非生产或公用事业工作对生产工作的绩效影响的量化限制。 公用事业的节流率由监督人员自动确定，使公用事业的影响力保持在规定的限度内。 自适应调节系统动态地适应工作负载的变化，以确保有价值的系统资源得到充分利用，并且公用事业工作不会不必要地延迟。
-
公开(公告)号：US08181050B2
公开(公告)日：2012-05-15
申请号：US12136486
申请日：2008-06-10
CPC分类号： G06F9/4843 , G06Q10/04
摘要： An adaptive throttling system for minimizing the impact of non-production work on production work in a computer system is provided. The adaptive throttling system throttles production work and non-production work to optimize production. The adaptive throttling system allows system administrators to specify a quantified limit on the performance impact of non-production or utility work on production work. The throttling rate of the utility is then automatically determined by a supervisory agent, so that the utilities' impact is kept within the specified limit. The adaptive throttling system adapts dynamically to changes in workloads so as to ensure that valuable system resources are well utilized and utility work is not delayed unnecessarily.
摘要翻译： 提供了一种用于最小化非生产工作对计算机系统中的生产工作的影响的自适应节流系统。 自适应节流系统节约生产工作和非生产工作，优化生产。 自适应调节系统允许系统管理员指定非生产或公用事业工作对生产工作的绩效影响的量化限制。 公用事业的节流率由监督人员自动确定，使公用事业的影响力保持在规定的限度内。 自适应调节系统动态地适应工作负载的变化，以确保有价值的系统资源得到充分利用，并且公用事业工作不会不必要地延迟。
-
公开(公告)号：US07137019B2
公开(公告)日：2006-11-14
申请号：US10427009
申请日：2003-04-30
CPC分类号： G06F9/4843 , G06Q10/04
摘要： An adaptive throttling system for minimizing the impact of non-production work on production work in a computer system. The adaptive throttling system throttles production work and non-production work to optimize production. The adaptive throttling system allows system administrators to specify a quantified limit on the performance impact of non-production or utility work on production work. The throttling rate of the utility is then automatically determined by a supervisory agent, so that the utilities' impact is kept within the specified limit. The adaptive throttling system adapts dynamically to changes in workloads so as to ensure that valuable system resources are well utilized and utility work is not delayed unnecessarily.
摘要翻译： 一种用于最小化非生产工作对计算机系统中的生产工作的影响的自适应节流系统。 自适应节流系统节约生产工作和非生产工作，优化生产。 自适应调节系统允许系统管理员指定非生产或公用事业工作对生产工作的绩效影响的量化限制。 公用事业的节流率由监督人员自动确定，使公用事业的影响力保持在规定的限度内。 自适应调节系统动态地适应工作负载的变化，以确保有价值的系统资源得到充分利用，并且公用事业工作不会不必要地延迟。
-
5.发明授权Method, system, and program for collecting statistics of data stored in a database 有权用于收集数据库中存储的数据的统计信息的方法，系统和程序公开(公告)号：US07739293B2
公开(公告)日：2010-06-15
申请号：US10996197
申请日：2004-11-22
CPC分类号： G06F17/30315
摘要： The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user's response experience.
摘要翻译： 本发明涉及为数据库中的数据自动采集统计信息。 提供了一种用于自动统计收集的方法，包括确定数据的统计数据已经改变的可能性; 并根据可能性收集数据的统计数据。 统计变更可能性的指标可能有助于触发自动统计收集。 具有显着变化的统计数据的表可能比稳定表的统计数据更频繁地收集。 提供了一个优选模型，以便于收集更相关的统计数据：按照观察到的表格模式计划收集表格; 如果满足阈值水平的活动，则考虑表的收集; 并对表进行采样，以预测要收集的统计信息是否发生变化。 收集统计信息时，限制和锁定争用可以最小化对数据库用户的响应体验的影响。
-
6.发明授权System and method for optimally configuring software systems for a NUMA platform 有权用于为NUMA平台优化配置软件系统的系统和方法公开(公告)号：US07302533B2
公开(公告)日：2007-11-27
申请号：US11077579
申请日：2005-03-11
申请人： James Liam Finnie , Taavi Andrew Burns , Matthew Albert Huras , Sunil Jeevananda Kamath , Lan Tuong Pham , Kevin R. Rose , Aamer Sachedina , Roger Luo Quan Zheng
发明人： James Liam Finnie , Taavi Andrew Burns , Matthew Albert Huras , Sunil Jeevananda Kamath , Lan Tuong Pham , Kevin R. Rose , Aamer Sachedina , Roger Luo Quan Zheng
IPC分类号： G06F12/00
CPC分类号： G06F9/5016 , G06F9/5061
摘要： A method and system for improving memory access patterns of software systems on NUMA systems discovers NUMA system resources where the NUMA system resources comprises a plurality of NUMA nodes; determines a plurality of database threads, processes, and objects for a database configuration; and generates a policy which assigns the plurality of database threads, processes, and objects to the plurality of NUMA nodes, wherein the generating of the policy is performed prior to initialization of the plurality of database threads, processes, and objects. The assignment of the database threads, processes, or objects to NUMA nodes is such that the amount of remote memory accesses is reduced. When the database thread, process, or object initializes, the database server queries the policy for its assigned NUMA node(s). The database thread, process, or object is then bound to the assigned NUMA node(s).
摘要翻译： 用于改进NUMA系统上的软件系统的存储器访问模式的方法和系统发现NUMA系统资源，其中NUMA系统资源包括多个NUMA节点; 确定数据库配置的多个数据库线程，进程和对象; 并且生成将所述多个数据库线程，进程和对象分配给所述多个NUMA节点的策略，其中在所述多个数据库线程，进程和对象的初始化之前执行所述策略的生成。 将数据库线程，进程或对象分配给NUMA节点使得远程内存访问量减少。 当数据库线程，进程或对象初始化时，数据库服务器向其分配的NUMA节点查询策略。 然后将数据库线程，进程或对象绑定到已分配的NUMA节点。
-
7.发明授权System, method and program for assessing the activity level of a database management system 失效用于评估数据库管理系统的活动级别的系统，方法和程序公开(公告)号：US07171519B2
公开(公告)日：2007-01-30
申请号：US10788582
申请日：2004-02-27
申请人： Matthew A. Huras , Kevin R. Rose , Aamer Sachedina
发明人： Matthew A. Huras , Kevin R. Rose , Aamer Sachedina
IPC分类号： G06F11/34
CPC分类号： G06F11/3409 , G06F17/3048 , G06F2201/80 , G06F2201/88 , G06F2201/885
摘要： A system and method for assessing the activity level of a database management system. The number of page fix operations performed by execution units of a database management system can be counted and used to compute a measure for the activity level of the database management system. In one embodiment of the invention, multiple counters are used to count the page fix operations. This and other embodiments of the invention facilitate activity level assessment without incurring significant performance penalty.
摘要翻译： 一种用于评估数据库管理系统的活动级别的系统和方法。 可以对数据库管理系统的执行单元执行的页面修复操作的数量进行计数，并用于计算数据库管理系统的活动级别的度量。 在本发明的一个实施例中，使用多个计数器来计数页面修复操作。 本发明的这个和其他实施例便于活动水平评估，而不会导致显着的性能损失。
-
-
-
-
-
-
搜索结果
7 条记录 (耗时 0.025 秒)
