New: tablehighcpuAll contenthive-129948krhive-196917steemzzanhive-166405hive-183959hive-180932hive-185836photographyuncommonlabhive-183397hive-150122hive-101145hive-188619hive-144064bitcoinhive-145157krsuccesslifehive-184714hive-109690hive-193637hive-103599hive-181136TrendingNewHotLikersdorvax (25)in sql • 6 years agoalert when CPU usage is High in SQL SERVERIF OBJECT_ID('tempdb..#TABLEHIGHCPU') IS NOT NULL DROP TABLE #TABLEHIGHCPU; CREATE TABLE #TABLEHIGHCPU ( C1 INT, C2 INT ); DECLARE @i INT = 1; WHILE (@i