#tablehighcpu

Follow to get notified about new posts with this tag

dorvax

7y

alert when CPU usage is High in SQL SERVER

alert when CPU usage is High in SQL SERVER

IF OBJECT_ID('tempdb..#TABLEHIGHCPU') IS NOT NULL DROP TABLE #TABLEHIGHCPU; CREATE TABLE #TABLEHIGHCPU ( C1 INT, C2 INT ); DECLARE @i INT = 1; WHILE (@i <= 12) -- Set Run time here; Value 6= 1 min (6x10sec)

$ 0.000

3