MSSQL query store: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " <code> SELECT qt.query_sql_text, rs.avg_duration, rs.count_executions, rs.avg_cpu_time, rsi.start_time, rsi.end_time FROM sys.query_store_runtime_stats rs JOIN sys.query_store_runtime_stats_interval rsi ON rs.runtime_stats_interval_id = rsi.runtime_stats_interval_id JOIN sys.query_store_plan p ON rs.plan_id = p.plan_id JOIN sys.query_store_query q ON p.query_id = q.query_id JOIN sys.query_store_query_text qt ON q.query_text_id = q...") |
Nessun oggetto della modifica |
||
| Riga 1: | Riga 1: | ||
< |
<pre> |
||
SELECT |
SELECT |
||
qt.query_sql_text, |
qt.query_sql_text, |
||
| Riga 19: | Riga 19: | ||
WHERE rsi.start_time >= '2026-06-11 14:00' |
WHERE rsi.start_time >= '2026-06-11 14:00' |
||
AND rsi.end_time <= '2026-06-11 16:00'; |
AND rsi.end_time <= '2026-06-11 16:00'; |
||
</ |
</pre> |
||
Versione attuale delle 14:42, 11 giu 2026
SELECT
qt.query_sql_text,
rs.avg_duration,
rs.count_executions,
rs.avg_cpu_time,
rsi.start_time,
rsi.end_time
FROM sys.query_store_runtime_stats rs
JOIN sys.query_store_runtime_stats_interval rsi
ON rs.runtime_stats_interval_id = rsi.runtime_stats_interval_id
JOIN sys.query_store_plan p
ON rs.plan_id = p.plan_id
JOIN sys.query_store_query q
ON p.query_id = q.query_id
JOIN sys.query_store_query_text qt
ON q.query_text_id = qt.query_text_id
WHERE rsi.start_time >= '2026-06-11 14:00'
AND rsi.end_time <= '2026-06-11 16:00';