Hi,

What actions do you perform if it reaches more than 90%. In my scenario, I have multiple SQL jobs which runs in while loop

e.g.

While(1=1)

begin

-- do something

-- delete top 500 records from x table of SERVER A and insert into x table of SERVER B

END

CPU usage of SERVER A reaches more than 90%. I know its because of infinite while loop but

I have to transfer the record from server A to Server B as soon as records gets entered into SERVER A.

Is there any way to deal with it.

Thanks, Satalaj.