Sql-server – SQL Delete (Suspended in activity monitor)

sql-serversql-server-2005

I have a table containing hundreds of entries and I am trying to delete a small range. It is taking a long time, in fact it is not being executed.

I monitored the query from the activity monitor and its status is "Suspended"

Is there anyone knows what may cause this problem?

Best Solution

What's the SQL you're running? Any triggers on the table, or any cascaded deletes to tables that have triggers on? Anything in the "Blocked By" column or Wait Type?

Try executing the following in management studio (on the database in question):

dbcc checkdb
dbcc checkcatalog