公开(公告)号：US20140089311A1

公开(公告)日：2014-03-27

申请号：US13627203

申请日：2012-09-26

申请人： Anita Richards ,  Douglas Brown ,  Bruce Britton ,  Todd Walter

发明人： Anita Richards ,  Douglas Brown ,  Bruce Britton ,  Todd Walter

IPC分类号： G06F17/30

CPC分类号： G06F11/0754 ,  G06F11/0727 ,  G06F16/217 ,  G06F16/2453 ,  G06F16/24549 ,  G06F16/24557

摘要： A system, method, and computer-readable medium that facilitate classification of database requests as problematic based on estimated processing characteristics of the request are provided. Estimated processing characteristics may include estimated skew including central processing unit skew and input/output operation skew, central processing unit duration per input/output operation, and estimated memory usage. The estimated processing characteristics are made on a request step basis. The request is classified as problematic responsive to determining one or more of the estimated characteristics of a request step exceed a corresponding threshold. In this manner, mechanisms for predicting bad query behavior are provided. Workload management of those requests may then be more successfully provided through workload throttles, filters, or even a more confident exception detection that correlates with the estimated bad behavior.

摘要翻译： 提供了一种系统，方法和计算机可读介质，其基于所请求的估计处理特性，有助于将数据库请求分类为有问题的。 估计的处理特性可以包括估计的偏差，包括中央处理单元偏移和输入/输出操作偏移，每个输入/输出操作的中央处理单元持续时间和估计的存储器使用。 估计的处理特性是在请求步骤的基础上进行的。 响应于确定请求步骤的估计特性中的一个或多个超过相应的阈值，将该请求分类为有问题的。 以这种方式，提供了用于预测不良查询行为的机制。 那么这些请求的工作负载管理可以通过工作负载节流，过滤器或甚至与估计的不良行为相关的更自信的异常检测来更成功地提供。