Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics

被引：11

作者：

Lee, Kukjin ^{[1
]}

Konig, Arnd Christian ^{[1
]}

Narasayya, Vivek ^{[1
]}

Ding, Bolin ^{[1
]}

Chaudhuri, Surajit ^{[1
]}

Ellwein, Brent ^{[1
]}

Eksarevskiy, Alexey ^{[1
]}

Kohli, Manbeen ^{[1
]}

Wyant, Jacob ^{[1
]}

Prakash, Praneeta ^{[1
]}

Nehme, Rimma ^{[1
]}

Li, Jiexing ^{[2
]}

Naughton, Jeff ^{[2
]}

机构：

[1] Microsoft Corp, Redmond, WA 98052 USA

[2] Univ Wisconsin, Madison, WI 53706 USA

来源：

SIGMOD'16: PROCEEDINGS OF THE 2016 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA | 2016年

关键词：

EXECUTION TIME;

D O I：

10.1145/2882903.2903728

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

We describe the design and implementation of the new Live Query Statistics (LQS) feature in Microsoft SQL Server 2016. The functionality includes the display of overall query progress as well as progress of individual operators in the query execution plan. We describe the overall functionality of LQS, give usage examples and detail all areas where we had to extend the current state-of-the-art to build the complete LQS feature. Finally, we evaluate the effect these extensions have on progress estimation accuracy with a series of experiments using a large set of synthetic and real workloads.

引用

页码：1753 / 1764

页数：12

共 12 条

[11] Fuzzy Statistics Estimation in Supporting Multidatabase Query Optimization
Department of Information Management, College of Management, National Sun Yat-Sen University, Kaohsiung, Taiwan
不详
AZ
85721, United States
不详
UT
84112, United States
Electronic Commerce Research, 2002, 2 (03) : 287 - 316
[12] Revising ready reference sites - Listening to users through server statistics and query logs
Mudrock, T
REFERENCE & USER SERVICES QUARTERLY, 2002, 42 (02) : 155 - 163

← 1 2 →