Query the list of factors on performance impact

With waits
(
Select wait_type,
Wait_time_ms/1000 as wait_time_s,
100. * wait_time_ms/sum (wait_time_ms) over () as PCT,
Row_number () over (order by wait_time_ms DESC) as Rn
From SYS. dm_ OS _wait_stats
Where wait_type not like '% Sleep %'
)
Select w1.wait _ type,
Cast (w1.wait _ time_s as decimal (12, 2) as wait_time_s,
Cast (w1.pct as decimal (12,2) as PCT, -- w2.pct, w1.rn, w2.rn
Cast (sum (w2.pct) as decimal (12,2) as running_pct
From waits W1 join waits W2
On w1.rn <= w2.rn
Group by w1.rn, w1.wait _ type, w1.wait _ time_s, w1.pct
Having sum (w2.pct)-w1.pct <90
Order by w1.rn