Query to keep CPU busy

 

-- set for 3 minutes below, do not run on production
-- ideal for testing CPU usage alerts

Declare @T DateTime,
@F Bigint;
Set @T=GetDate();
While DATEADD(Second,180,@T)>GETDATE()
Set @F=POWER(2,30);