Collecting runtime statistics

In the previous two subsections, you saw two kinds of information: query details and execution plan. Now it is time for execution statistics parameters. You will query a new catalog view:

SELECT * FROM sys.query_store_runtime_stats; 

The output is shown in the following screenshot:

Check collected runtime statistics in Query Store

Again, the output generated when you execute the previous query can differ from the one shown in the preceding screenshot. The sys.query_store_runtime_stats catalog view contains runtime execution statistics information for the query. A full list and descriptions of all attributes of ...

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.