Delete query stuck in suspended status
-
I kicked off a Delete where value > 2 statement. I didn't expect it take take more than a couple of minutes, which has been the case for similar deletes on similar tables. But, it has been executing for 34 minutes, and when I run this statement, the status is suspended.
SELECT start_time, status, command FROM sys.dm_exec_requests
Any ideas as to how to check if or why the initial query is suspended or seemingly not running anymore. Edit: Using SQL '05, have seen some answers that suggest upgrading the SP2, but that is not an option right now. Could this be related to lack of space on the drive where the tempdb and masterdb are stored and the OS is running?
Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson
-
I kicked off a Delete where value > 2 statement. I didn't expect it take take more than a couple of minutes, which has been the case for similar deletes on similar tables. But, it has been executing for 34 minutes, and when I run this statement, the status is suspended.
SELECT start_time, status, command FROM sys.dm_exec_requests
Any ideas as to how to check if or why the initial query is suspended or seemingly not running anymore. Edit: Using SQL '05, have seen some answers that suggest upgrading the SP2, but that is not an option right now. Could this be related to lack of space on the drive where the tempdb and masterdb are stored and the OS is running?
Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson
Ok, it is a pageiolatch issue, lack of disk space.
Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson
-
Ok, it is a pageiolatch issue, lack of disk space.
Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson
Only a computer programmer would make a delete operation fail because there is not enough space. :cool:
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
Only a computer programmer would make a delete operation fail because there is not enough space. :cool:
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
Ugh, I had too much faith in the admin. I moved the files for my Database to the E drive with enough space. He had a C drive as the OS drive with only 12 gig, and a D drive that was, from my understanding, supposed to be for programs, including SQL. The clown admin installed SQL to the system C drive with very limited space. It turns out the temp table and log files were getting full, jamming up the OS/SQL D: drive. I should say that this definitely is not my fault, as I don't remote to the machine ever, just use SQL Server Management Studio. So there was no way for me to be worried about it, or know about it even.
Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson