Title | ||
---|---|---|
Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics. |
Abstract | ||
---|---|---|
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. |
Year | DOI | Venue |
---|---|---|
2016 | 10.1145/2882903.2903728 | SIGMOD Conference |
Field | DocType | Citations |
Data mining,Query language,Computer science,Query optimization,Web search query,Information retrieval,Query expansion,Language Integrated Query,Sargable,Query by Example,Database administrator,Statistics,Database | Conference | 5 |
PageRank | References | Authors |
0.41 | 21 | 13 |
Name | Order | Citations | PageRank |
---|---|---|---|
Kukjin Lee | 1 | 7 | 1.46 |
Arnd Christian König | 2 | 718 | 121.72 |
Vivek Narasayya | 3 | 1642 | 173.24 |
Bolin Ding | 4 | 1578 | 85.48 |
Surajit Chaudhuri | 5 | 9971 | 1373.71 |
Brent Ellwein | 6 | 5 | 0.41 |
Alexey Eksarevskiy | 7 | 5 | 0.41 |
Manbeen Kohli | 8 | 5 | 0.41 |
Jacob Wyant | 9 | 5 | 0.41 |
Praneeta Prakash | 10 | 5 | 0.41 |
Rimma V. Nehme | 11 | 202 | 13.28 |
Jiexing Li | 12 | 211 | 10.36 |
Jeffrey F. Naughton | 13 | 8363 | 1913.71 |