Identificare le query più pesanti e lente in esecuzione

[FrancyDotNet]

Le query più pesanti

Codice: Seleziona tutto

SELECT
    TOP 10
    total_worker_time / execution_count AS Avg_CPU_Time,
    total_elapsed_time / execution_count AS AVG_Run_Time,
    (SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS Query_Text,
    execution_count
FROM
    sys.dm_exec_query_stats
ORDER BY
    Avg_CPU_Time DESC;

Le query più lente

Codice: Seleziona tutto

SELECT 
    sqltext.TEXT,
    req.session_id,
    req.status,
    req.start_time
FROM 
    sys.dm_exec_requests req
CROSS APPLY 
    sys.dm_exec_sql_text(sql_handle) AS sqltext
WHERE 
    req.start_time <= DATEADD(MINUTE, -1, GETDATE())