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

適用対象: ○SQL Server 2016 以降 ○Azure SQL Database ○Azure Synapse Analytics (SQL DW) XParallel Data Warehouse APPLIES TO: yesSQL Server 2016 and later yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

クエリのランタイム実行統計情報が収集された各間隔の開始時刻と終了時刻に関する情報を格納します。Contains information about the start and end time of each interval over which runtime execution statistics information for a query has been collected.

列名Column name データ型Data type [説明]Description
runtime_stats_interval_idruntime_stats_interval_id bigintbigint 主キーPrimary key.
start_timestart_time datetimeoffsetdatetimeoffset 間隔の開始時刻。Start time of the interval.
end_timeend_time datetimeoffsetdatetimeoffset 間隔の終了時刻。End time of the interval.
関するcomment nvarchar (32)nvarchar(32) 常に NULL です。Always NULL.

アクセス許可Permissions

VIEW DATABASE STATE権限が必要です。Requires the VIEW DATABASE STATE permission.

参照See Also

database_query_store_options (Transact-sql) sys.database_query_store_options (Transact-SQL)
query_context_settings (Transact-sql) sys.query_context_settings (Transact-SQL)
query_store_plan (Transact-sql) sys.query_store_plan (Transact-SQL)
query_store_query (Transact-sql) sys.query_store_query (Transact-SQL)
query_store_query_text (Transact-sql) sys.query_store_query_text (Transact-SQL)
query_store_runtime_stats (Transact-sql) sys.query_store_runtime_stats (Transact-SQL)
query_store_wait_stats (Transact-sql)sys.query_store_wait_stats (Transact-SQL)
クエリのストアを使用した、パフォーマンスの監視 Monitoring Performance By Using the Query Store
カタログ ビュー (Transact-SQL) Catalog Views (Transact-SQL)
Transact-sql)(のストアドプロシージャのクエリストアQuery Store Stored Procedures (Transact-SQL)