Proccessor goes 100% Deleting rows 1

[tommyspain]

Hi all:

I made a stored procedure as recomended to delete thousands of rows but, why is proccessor burning at 100%? and, how can I monitor it to know what is it doing?

This is the procedure fired from a job in Server Manager:

CREATE PROCEDURE deletingStat AS

Declare @rc int
Select @rc=100

while @rc=100
Begin
Begin Transaction
DELETE FROM statLiberando
Select @rc=@@rowcount
Commit
End
GO

 

[TJRTech]

Why not just truncate the table if deleting ALL the records within?

truncate table statLiberando