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 条

[1] QUERY OPTIMIZATION IN MICROSOFT SQL SERVER
Haxhijaha, Blerta
Ajdari, Jaumin
Raufi, Bujar
Zenuni, Xhemal
Ismaili, Florie
INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY, 2018, 10 (02): : 13 - 22
[2] Distributed/heterogeneous query processing in microsoft SQL server
Blakeley, JA
Cunningham, C
Ellis, N
Rathakrishnan, B
Wu, MC
ICDE 2005: 21ST INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2005, : 1001 - 1012
[3] Query-by-Example Image Retrieval in Microsoft SQL Server
Staszewski, Pawel
Woldan, Piotr
Korytkowski, Marcin
Scherer, Rafal
Wang, Lipo
ARTIFICIAL INTELLIGENCE AND SOFT COMPUTING, (ICAISC 2016), PT II, 2016, 9693 : 746 - 754
[4] Geospatial Stream Query Processing using Microsoft SQL Server StreamInsight
Kazemitabar, Seyed Jalal
Demiryurek, Ugur
Ali, Mohamed H.
Akdogan, Afsin
Shahabi, Cyrus
PROCEEDINGS OF THE VLDB ENDOWMENT, 2010, 3 (02): : 1537 - 1540
[5] Evaluation of Sub Query Performance in SQL Server
Oktavia, Tanty
Sujarwo, Surya
ICASCE 2013 - INTERNATIONAL CONFERENCE ON ADVANCES SCIENCE AND CONTEMPORARY ENGINEERING, 2014, 68
[6] On Index-based Query in SQL Server Database
Qi Chunxia
PROCEEDINGS OF THE 35TH CHINESE CONTROL CONFERENCE 2016, 2016, : 9519 - 9523
[7] Multi-query SQL progress indicators
Luo, Gang
Naughton, Jeffrey F.
Yu, Philip S.
ADVANCES IN DATABASE TECHNOLOGY - EDBT 2006, 2006, 3896 : 921 - 941
[8] Organization and Query of Point Clouds Data Based on SQL Server Spatial
Chen, Yijin
Zhang, Huixia
Fu, Xiaoxue
PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 7, 2010, : 178 - 181
[9] A web page query technology based on ASP.NET and SQL Server
Zhao, Guangshun
Meng, Qingjin
Bi, Jianxue
2021 PROCEEDINGS OF THE 40TH CHINESE CONTROL CONFERENCE (CCC), 2021, : 6466 - 6469
[10] Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server
Lee, Kukjin
Dutt, Anshuman
Narasayya, Vivek
Chaudhuri, Surajit
PROCEEDINGS OF THE VLDB ENDOWMENT, 2023, 16 (11): : 2871 - 2883

← 1 2 →