Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Deletes takes a long time, but CPU, Disk and RAM untroubled...why ? RE: Deletes takes a long time, but CPU, Disk and RAM untroubled...why ?
Super Cat
SSCertifiable
Points: 7332
More actions
September 24, 2013 at 6:25 am
#1652685
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.