Category : Waits

1 article

Wait stats

Identifie les principales attentes de l’instance. Source Glenn Berry et Paul Randal. /*——————————————————————- [SCRIPT] wait_stats [DATABASE] master [DESCRIPTION] Identifie les principales attentes ——————————————————————-*/ — Source Glenn Berry Diagnostic Information Queries : http://sqlskills.com/blogs/glenn/ — SQL Server Wait Types Library (Paul Randal) : https://www.sqlskills.com/help/waits/ WITH [Waits] AS (SELECT wait_type, wait_time_ms/ 1000.0 AS […]