sys. query_store_runtime_stats (Transact-sql) sys.query_store_runtime_stats (Transact-SQL)

适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更高版本 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) and later 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics

包含有关查询的运行时执行统计信息的信息。Contains information about the runtime execution statistics information for the query.

列名称Column name 数据类型Data type 说明Description
runtime_stats_idruntime_stats_id bigintbigint 表示 plan_idexecution_typeruntime_stats_interval_id的运行时执行统计信息的行标识符。Identifier of the row representing runtime execution statistics for the plan_id, execution_type and runtime_stats_interval_id. 只有过去运行时统计信息间隔才是唯一的。It is unique only for the past runtime statistics intervals. 对于当前处于活动状态的时间间隔,可能有多个行表示 plan_id引用的计划的运行时统计信息,并且执行类型由 execution_type表示。For currently active interval there may be multiple rows representing runtime statistics for the plan referenced by plan_id, with the execution type represented by execution_type. 通常,一行代表刷新到磁盘上的运行时统计信息,而其他 () 表示内存中状态。Typically, one row represents runtime statistics that are flushed to disk, while other(s) represent in-memory state. 因此,若要获取每个间隔的实际状态,需要聚合指标,按 plan_idexecution_typeruntime_stats_interval_id进行分组。Hence, to get actual state for every interval you need to aggregate metrics, grouping by plan_id, execution_type and runtime_stats_interval_id.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
plan_idplan_id bigintbigint 外键。Foreign key. 联接到 sys.databases)的 query_store_plan (Joins to sys.query_store_plan (Transact-SQL).
runtime_stats_interval_idruntime_stats_interval_id bigintbigint 外键。Foreign key. 联接到 sys.databases)的 query_store_runtime_stats_interval (Joins to sys.query_store_runtime_stats_interval (Transact-SQL).
execution_typeexecution_type tinyinttinyint 确定查询执行的类型:Determines type of query execution:

0-常规执行 (成功完成) 0 - Regular execution (successfully finished)

3-客户端启动的已中止执行3 - Client initiated aborted execution

4-异常中止执行4 - Exception aborted execution
execution_type_descexecution_type_desc nvarchar(128)nvarchar(128) 执行类型字段的文本说明:Textual description of the execution type field:

0-常规0 - Regular

3-已中止3 - Aborted

4-异常4 - Exception
first_execution_timefirst_execution_time datetimeoffsetdatetimeoffset 查询计划在聚合间隔内的第一次执行时间。First execution time for the query plan within the aggregation interval. 这是指查询执行的结束时间。This refers to the end time of the query execution.
last_execution_timelast_execution_time datetimeoffsetdatetimeoffset 查询计划在聚合间隔内的上次执行时间。Last execution time for the query plan within the aggregation interval. 这是指查询执行的结束时间。This refers to the end time of the query execution.
count_executionscount_executions bigintbigint 聚合间隔内查询计划执行的总次数。Total count of executions for the query plan within the aggregation interval.
avg_durationavg_duration floatfloat 聚合间隔内查询计划的平均持续时间,以微秒) (报告。Average duration for the query plan within the aggregation interval (reported in microseconds) .
last_durationlast_duration bigintbigint 聚合间隔内查询计划的上次持续时间(以微秒) (报告)。Last duration for the query plan within the aggregation interval (reported in microseconds).
min_durationmin_duration bigintbigint 聚合间隔内查询计划的最短持续时间(以微秒) (报告)。Minimum duration for the query plan within the aggregation interval (reported in microseconds).
max_durationmax_duration bigintbigint 聚合间隔内查询计划的最长持续时间(以微秒) (报告)。Maximum duration for the query plan within the aggregation interval (reported in microseconds).
stdev_durationstdev_duration floatfloat 聚合间隔内查询计划的持续时间标准偏差 (以微秒为单位报告) 。Duration standard deviation for the query plan within the aggregation interval (reported in microseconds).
avg_cpu_timeavg_cpu_time floatfloat 聚合间隔内查询计划的平均 CPU 时间(以微秒) (报告)。Average CPU time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_cpu_timelast_cpu_time bigintbigint 聚合间隔内查询计划的上次 CPU 时间(以微秒为单位 (报告)) 。Last CPU time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_cpu_timemin_cpu_time bigintbigint 聚合间隔内查询计划的最小 CPU 时间(以微秒) (报告)。Minimum CPU time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_cpu_timemax_cpu_time bigintbigint 聚合间隔内查询计划的最大 CPU 时间(以微秒) (报告)。Maximum CPU time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_cpu_timestdev_cpu_time floatfloat 聚合间隔内查询计划的 CPU 时间标准偏差 (以微秒为单位报告) 。CPU time standard deviation for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_logical_io_readsavg_logical_io_reads floatfloat 聚合间隔内查询计划的平均逻辑 i/o 数。Average number of logical I/O reads for the query plan within the aggregation interval. (表示为多个8KB 页面,) 读取。(expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_logical_io_readslast_logical_io_reads bigintbigint 聚合间隔内查询计划的最后逻辑 i/o 读取次数。Last number of logical I/O reads for the query plan within the aggregation interval. (表示为多个8KB 页面,) 读取。(expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_logical_io_readsmin_logical_io_reads bigintbigint 聚合间隔内查询计划的最小逻辑 i/o 读取次数。Minimum number of logical I/O reads for the query plan within the aggregation interval. (表示为多个8KB 页面,) 读取。(expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_logical_io_readsmax_logical_io_reads bigintbigint 聚合间隔内查询计划的最大逻辑 i/o 读取次数。 (表示为多个8KB 页面读取) 。Maximum number of logical I/O reads for the query plan within the aggregation interval.(expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_logical_io_readsstdev_logical_io_reads floatfloat 逻辑 i/o 读取聚合间隔内查询计划的标准偏差。Number of logical I/O reads standard deviation for the query plan within the aggregation interval. (表示为多个8KB 页面,) 读取。(expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_logical_io_writesavg_logical_io_writes floatfloat 聚合间隔内查询计划的平均逻辑 i/o 写入数。Average number of logical I/O writes for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_logical_io_writeslast_logical_io_writes bigintbigint 聚合间隔内查询计划的最后逻辑 i/o 写入次数。Last number of logical I/O writes for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_logical_io_writesmin_logical_io_writes bigintbigint 聚合间隔内查询计划的最小逻辑 i/o 写入次数。Minimum number of logical I/O writes for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_logical_io_writesmax_logical_io_writes bigintbigint 聚合间隔内查询计划的逻辑 i/o 写入最大次数。Maximum number of logical I/O writes for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_logical_io_writesstdev_logical_io_writes floatfloat 逻辑 i/o 数在聚合间隔内写入查询计划的标准偏差。Number of logical I/O writes standard deviation for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_physical_io_readsavg_physical_io_reads floatfloat 聚合间隔内查询计划的平均物理 i/o 读取次数 (表示为多个8KB 页面读取) 。Average number of physical I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_physical_io_readslast_physical_io_reads bigintbigint 聚合间隔内查询计划的最后物理 i/o 读取次数 (表示为多个8KB 页面读取) 。Last number of physical I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_physical_io_readsmin_physical_io_reads bigintbigint 聚合间隔内查询计划的最小物理 i/o 读取次数 (表示为多个8KB 页面读取) 。Minimum number of physical I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_physical_io_readsmax_physical_io_reads bigintbigint 聚合间隔内查询计划的最大物理 i/o 读取次数 (表示为多个8KB 页面读取) 。Maximum number of physical I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_physical_io_readsstdev_physical_io_reads floatfloat 物理 i/o 读取聚合间隔内查询计划的标准偏差 (表示为多个8KB 页面读取) 。Number of physical I/O reads standard deviation for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_clr_timeavg_clr_time floatfloat 聚合间隔内查询计划的平均 CLR 时间 (以微秒为单位报告) 。Average CLR time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_clr_timelast_clr_time bigintbigint 聚合间隔内查询计划的上次 CLR 时间 (以微秒为单位报告) 。Last CLR time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_clr_timemin_clr_time bigintbigint 聚合间隔内查询计划的最小 CLR 时间 (以微秒为单位报告) 。Minimum CLR time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_clr_timemax_clr_time bigintbigint 聚合间隔内查询计划的最大 CLR 时间 (以微秒为单位报告) 。Maximum CLR time for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_clr_timestdev_clr_time floatfloat 聚合间隔内查询计划的 CLR 时间标准偏差 (以微秒为单位报告) 。CLR time standard deviation for the query plan within the aggregation interval (reported in microseconds).
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_dopavg_dop floatfloat 聚合间隔内查询计划) 平均 DOP (并行度。Average DOP (degree of parallelism) for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_doplast_dop bigintbigint 上次 DOP (聚合间隔内查询计划) 的并行度。Last DOP (degree of parallelism) for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_dopmin_dop bigintbigint 聚合间隔内查询计划) 的最小 DOP (并行度。Minimum DOP (degree of parallelism) for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_dopmax_dop bigintbigint 最大 DOP (了聚合间隔内查询计划) 的并行度。Maximum DOP (degree of parallelism) for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_dopstdev_dop floatfloat DOP (聚合间隔内查询计划的标准偏差) 并行度。DOP (degree of parallelism) standard deviation for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_query_max_used_memoryavg_query_max_used_memory floatfloat 平均内存授予 (报告为聚合间隔内查询计划) 的 8 KB 页的数目。Average memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. 对于使用本机编译的内存优化过程的查询,始终为0。Always 0 for queries using natively compiled memory optimized procedures.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_query_max_used_memorylast_query_max_used_memory bigintbigint 上次内存授予 (报告为聚合间隔内查询计划) 的 8 KB 页的数目。Last memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. 对于使用本机编译的内存优化过程的查询,始终为0。Always 0 for queries using natively compiled memory optimized procedures.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_query_max_used_memorymin_query_max_used_memory bigintbigint 在聚合间隔内,将 (报告为查询计划) 的 8 KB 页的数目。Minimum memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. 对于使用本机编译的内存优化过程的查询,始终为0。Always 0 for queries using natively compiled memory optimized procedures.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_query_max_used_memorymax_query_max_used_memory bigintbigint 最大内存授予 (报告为聚合间隔内查询计划) 的 8 KB 页的数目。Maximum memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. 对于使用本机编译的内存优化过程的查询,始终为0。Always 0 for queries using natively compiled memory optimized procedures.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_query_max_used_memorystdev_query_max_used_memory floatfloat 内存授予标准偏差 (报告为聚合间隔内查询计划) 的 8 KB 页的数目。Memory grant standard deviation (reported as the number of 8 KB pages) for the query plan within the aggregation interval. 对于使用本机编译的内存优化过程的查询,始终为0。Always 0 for queries using natively compiled memory optimized procedures.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_rowcountavg_rowcount floatfloat 聚合间隔内查询计划的返回行的平均数目。Average number of returned rows for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_rowcountlast_rowcount bigintbigint 上次在聚合间隔内执行查询计划时返回的行数。Number of returned rows by the last execution of the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_rowcountmin_rowcount bigintbigint 聚合间隔内查询计划返回的最小行数。Minimum number of returned rows for the query plan within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_rowcountmax_rowcount bigintbigint 聚合间隔内查询计划返回的最大行数。Maximum number of returned rows for the query plan within the aggregation interval.
stdev_rowcountstdev_rowcount floatfloat 聚合间隔内查询计划的返回行数标准偏差。Number of returned rows standard deviation for the query plan within the aggregation interval.
avg_log_bytes_usedavg_log_bytes_used floatfloat 查询计划在聚合间隔内使用的数据库日志中的平均字节数。Average number of bytes in the database log used by the query plan, within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
last_log_bytes_usedlast_log_bytes_used bigintbigint 上次执行查询计划时在聚合间隔内使用的数据库日志中的字节数。Number of bytes in the database log used by the last execution of the query plan, within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
min_log_bytes_usedmin_log_bytes_used bigintbigint 查询计划在聚合间隔内使用的数据库日志中的最小字节数。Minimum number of bytes in the database log used by the query plan, within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
max_log_bytes_usedmax_log_bytes_used bigintbigint 查询计划在聚合间隔内使用的数据库日志中的最大字节数。Maximum number of bytes in the database log used by the query plan, within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
stdev_log_bytes_usedstdev_log_bytes_used floatfloat 查询计划在聚合间隔内使用的数据库日志中的字节数的标准偏差。Standard deviation of the number of bytes in the database log used by a query plan, within the aggregation interval.
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse) will always return zero (0).
avg_tempdb_space_usedavg_tempdb_space_used floatfloat 聚合间隔内 tempdb 中用于查询计划的平均页数 (表示为多个8KB 页面) 。Average number of pages used in tempdb for the query plan within the aggregation interval (expressed as a number of 8KB pages).

适用于: SQL ServerSQL Server(从 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 开始)和 Azure SQL 数据库Azure SQL DatabaseApplies to: SQL ServerSQL Server (Starting with SQL Server 2017 (14.x)SQL Server 2017 (14.x)) and Azure SQL 数据库Azure SQL Database.
last_tempdb_space_usedlast_tempdb_space_used bigintbigint 聚合间隔内 tempdb 中用于查询计划的最后几个页面数 (表示为多个8KB 页面) 。Last number of pages used in tempdb for the query plan within the aggregation interval (expressed as a number of 8KB pages).

适用于: SQL ServerSQL Server(从 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 开始)和 Azure SQL 数据库Azure SQL DatabaseApplies to: SQL ServerSQL Server (Starting with SQL Server 2017 (14.x)SQL Server 2017 (14.x)) and Azure SQL 数据库Azure SQL Database.
min_tempdb_space_usedmin_tempdb_space_used bigintbigint 聚合间隔内 tempdb 中用于查询计划的最小页数 (表示为多个8KB 页面) 。Minimum number of pages used in tempdb for the query plan within the aggregation interval (expressed as a number of 8KB pages).

适用于: SQL ServerSQL Server(从 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 开始)和 Azure SQL 数据库Azure SQL DatabaseApplies to: SQL ServerSQL Server (Starting with SQL Server 2017 (14.x)SQL Server 2017 (14.x)) and Azure SQL 数据库Azure SQL Database.
max_tempdb_space_usedmax_tempdb_space_used bigintbigint 聚合间隔内 tempdb 中用于查询计划的最大页数 (表示为多个8KB 页面) 。Maximum number of pages used in tempdb for the query plan within the aggregation interval (expressed as a number of 8KB pages).

适用于: SQL ServerSQL Server(从 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 开始)和 Azure SQL 数据库Azure SQL DatabaseApplies to: SQL ServerSQL Server (Starting with SQL Server 2017 (14.x)SQL Server 2017 (14.x)) and Azure SQL 数据库Azure SQL Database.
stdev_tempdb_space_usedstdev_tempdb_space_used floatfloat 聚合间隔内的查询计划的 tempdb 标准偏差中使用的页数 (表示为多个8KB 页面) 。Number of pages used in tempdb standard deviation for the query plan within the aggregation interval (expressed as a number of 8KB pages).

适用于: SQL ServerSQL Server(从 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 开始)和 Azure SQL 数据库Azure SQL DatabaseApplies to: SQL ServerSQL Server (Starting with SQL Server 2017 (14.x)SQL Server 2017 (14.x)) and Azure SQL 数据库Azure SQL Database.
avg_page_server_io_readsavg_page_server_io_reads floatfloat 聚合间隔内查询计划的平均页面服务器 i/o 数 (表示为多个8KB 页面读取) 。Average number of page server I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).

适用于: Azure SQL Database 超大规模Applies to: Azure SQL Database Hyperscale
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse)Azure SQL 数据库Azure SQL DatabaseAzure SQL 托管实例Azure SQL Managed Instance (非超大规模) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse), Azure SQL 数据库Azure SQL Database, Azure SQL 托管实例Azure SQL Managed Instance (non-hyperscale) will always return zero (0).
last_page_server_io_readslast_page_server_io_reads bigintbigint 聚合间隔内查询计划的上次页面服务器 i/o 读取次数 (表示为多个8KB 页面读取) 。Last number of page server I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).

适用于: Azure SQL 数据库Azure SQL Database 超大规模Applies to: Azure SQL 数据库Azure SQL Database Hyperscale
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse)Azure SQL 数据库Azure SQL DatabaseAzure SQL 托管实例Azure SQL Managed Instance (非超大规模) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse), Azure SQL 数据库Azure SQL Database, Azure SQL 托管实例Azure SQL Managed Instance (non-hyperscale) will always return zero (0).
min_page_server_io_readsmin_page_server_io_reads bigintbigint 聚合间隔内查询计划的最小页服务器 i/o 读取数 (表示为多个8KB 页读取) 。Minimum number of page server I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).

适用于: Azure SQL 数据库Azure SQL Database 超大规模Applies to: Azure SQL 数据库Azure SQL Database Hyperscale
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse)Azure SQL 数据库Azure SQL DatabaseAzure SQL 托管实例Azure SQL Managed Instance (非超大规模) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse), Azure SQL 数据库Azure SQL Database, Azure SQL 托管实例Azure SQL Managed Instance (non-hyperscale) will always return zero (0).
max_page_server_io_readsmax_page_server_io_reads bigintbigint 聚合间隔内查询计划的最大页服务器 i/o 读取数 (表示为多个8KB 页读取) 。Maximum number of page server I/O reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).

适用于: Azure SQL 数据库Azure SQL Database 超大规模Applies to: Azure SQL 数据库Azure SQL Database Hyperscale
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse)Azure SQL 数据库Azure SQL DatabaseAzure SQL 托管实例Azure SQL Managed Instance (非超大规模) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse), Azure SQL 数据库Azure SQL Database, Azure SQL 托管实例Azure SQL Managed Instance (non-hyperscale) will always return zero (0).
stdev_page_server_io_readsstdev_page_server_io_reads floatfloat 页面服务器 i/o 数在聚合间隔内读取查询计划的标准偏差 (表示为多个8KB 页面读取) 。Number of page server I/O reads standard deviation for the query plan within the aggregation interval (expressed as a number of 8KB pages read).

适用于: Azure SQL 数据库Azure SQL Database 超大规模Applies to: Azure SQL 数据库Azure SQL Database Hyperscale
注意: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse)Azure SQL 数据库Azure SQL DatabaseAzure SQL 托管实例Azure SQL Managed Instance (非超大规模) 将始终返回零 (0) 。Note: Azure Synapse Analytics(SQL 数据仓库)Azure Synapse Analytics (SQL Data Warehouse), Azure SQL 数据库Azure SQL Database, Azure SQL 托管实例Azure SQL Managed Instance (non-hyperscale) will always return zero (0).

权限Permissions

需要 VIEW DATABASE STATE 权限。Requires the VIEW DATABASE STATE permission.

另请参阅See Also

sys. database_query_store_options (Transact-sql) sys.database_query_store_options (Transact-SQL)
sys. query_context_settings (Transact-sql) sys.query_context_settings (Transact-SQL)
sys. query_store_plan (Transact-sql) sys.query_store_plan (Transact-SQL)
sys. query_store_query (Transact-sql) sys.query_store_query (Transact-SQL)
sys. query_store_query_text (Transact-sql) sys.query_store_query_text (Transact-SQL)
sys.query_store_wait_stats (Transact-SQL)sys.query_store_wait_stats (Transact-SQL)
sys. query_store_runtime_stats_interval (Transact-sql) sys.query_store_runtime_stats_interval (Transact-SQL)
相关视图、函数和过程 Monitoring Performance By Using the Query Store
目录视图 (Transact-SQL) Catalog Views (Transact-SQL)
查询存储存储过程 (Transact-SQL) Query Store Stored Procedures (Transact-SQL)
Query Store 最佳实践Best Practice with the Query Store