Invention Grant
US08099399B2 Determining whether change in workload of database system has occurred, and/or whether executing current workload will likely result in problem developing with database system
有权
确定数据库系统的工作负载是否发生变化,和/或执行当前工作负荷是否会导致数据库系统发生问题
- Patent Title: Determining whether change in workload of database system has occurred, and/or whether executing current workload will likely result in problem developing with database system
- Patent Title (中): 确定数据库系统的工作负载是否发生变化,和/或执行当前工作负荷是否会导致数据库系统发生问题
-
Application No.: US12509704Application Date: 2009-07-27
-
Publication No.: US08099399B2Publication Date: 2012-01-17
- Inventor: William K. Wilkinson , Harumi Kuno , Goetz Graefe
- Applicant: William K. Wilkinson , Harumi Kuno , Goetz Graefe
- Applicant Address: US TX Houston
- Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee Address: US TX Houston
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Whether a change in workload of a database system has occurred can be determined. Investigative queries are formulated. Each investigative query is adapted to test a different resource or a different combination of resources of the database system. The investigative queries are run when the database system is in an unloaded state to acquire unloaded performance metrics. The investigative queries are run when the database system is in a loaded state to acquire loaded performance metrics. Whether executing a current workload of the database system, using a current configuration of the database system, will likely result in a problem developing at a later point in time can also be determined. Simultaneously with actual execution of the current workload on the database system using the current configuration, a simulation of execution of the current workload using the current configuration is performed. The simulation is performed more quickly than the actual execution.
Public/Granted literature
Information query