• What are the data types of the tsble, are there any large data types ie VARCHAR(MAX),TEXT etc.

    What is the data size of the whole table.

    Is it waiting to get exclusive access to the table

    SELECT * from sys.sysprocesses where blocked <> 0.