26、Azure SQL性能监控、异常处理与应用洞察集成全解析

Azure SQL性能监控、异常处理与应用洞察集成全解析

1. Query Store的强大功能

Query Store是Azure SQL中一个非常实用的功能，它能帮助我们监控和排查数据库性能问题。以下是一些具体的应用场景和操作方法：
- 查询最近执行时间较长的查询 ：

SELECT TOP 10 rs.avg_duration, qt.query_sql_text,
    q.query_id, qt.query_text_id, p.plan_id, rs.runtime_stats_id,
    rsi.start_time, rsi.end_time, rs.avg_rowcount, rs.count_executions
FROM sys.query_store_query_text AS qt
JOIN sys.query_store_query AS q
    ON qt.query_text_id = q.query_text_id
JOIN sys.query_store_plan AS p
    ON q.query_id = p.query_id
JOIN sys.query_store_runtime_stats AS rs
    ON p.plan_id = rs.plan_id
JOIN sys.query_store_runtime_stats_interval AS rsi
    ON rsi.runtime_stats_interval_id = rs.runtime_stats_interval_id
WHERE rs.last_executio