It started after a DTS package Job got hung and it had to be stopped manually. Job status has changed to "Not Running" but apparantly a Delete statement has stuck into infinite loop.
Here is the data from SQL profiler:
Application Name: Microsoft SQL Server
ClientProcessID: 23895
SPID: "Keeps Changing"
TextData: Delete statement.... Network Protocol ---LPC
Can't restart SQLServer right now, is there any other option?