- 专利标题: Query performance degradation analysis timing
-
申请号: US15629469申请日: 2017-06-21
-
公开(公告)号: US10534774B2公开(公告)日: 2020-01-14
- 发明人: Nikola Obradovic , Dejan Krakovic , Vanja Vuksic
- 申请人: Microsoft Technology Licensing, LLC
- 申请人地址: US WA Redmond
- 专利权人: Microsoft Technology Licensing, LLC
- 当前专利权人: Microsoft Technology Licensing, LLC
- 当前专利权人地址: US WA Redmond
- 代理机构: Workman Nydegger
- 主分类号: G06F16/2453
- IPC分类号: G06F16/2453 ; G06F11/34 ; G06F16/21
摘要:
Mechanisms for improving resource usage of a computing system by properly balancing the timing of performance degradation analysis of an executable action set of a query based on an impact on the workload of that query. The mechanism collects workload metrics for each of multiple queries and their associated executable action sets. Performance degradation occurs when the current executed action set is no longer appropriate for the corresponding query such that more resources are used than are necessary. For each query, the system determines whether to perform degradation analysis of the current executable action set in a manner that is workload aware. That is, queries that occupy more computing resources or that impact the overall workload more will tend to have degradation analysis performed more frequently than those queries that have less impact on the overall workload. This results in improved resource usage for the workload with low overhead.
公开/授权文献
- US20180373758A1 QUERY PERFORMANCE DEGRADATION ANALYSIS TIMING 公开/授权日:2018-12-27
信息查询