September 15, 2010 at 10:22 am
:crying:hi gurus, i need your help, i have a database in my sql 2005 database sp3 that is currently unacessible, i was able to see what i running an the only thing that is running is the same ghost cleanup spid for the last two hours, i see this in the error log as well:
The operating system returned error 1450(Insufficient system resources exist to complete the requested service.) to SQL Server during a write at offset 0x00002274bf8000 in file with handle 0x0000000000000958. This is usually a temporary condition and the SQL Server will keep retrying the operation. If the condition persists then immediate action must be taken to correct it.
can someone help what can be causing this? should i kill the spid running the ghost cleanup? or is this an operating system issue?
September 15, 2010 at 10:36 am
Ghost Cleanup is an internal SQL Server process that clens up the ghost records.
Whebnver a delete happens the deleted record is not deleted physically. As such deleted records are marked as ghost records. And a dedicated SQL Server process called Ghost cleanup later deletes those ghost records physically.
But ghost cleanup can't delete the ghost record if the delete transaction is not committed. It runs every 5 secs.
Please check for any uncommitted transactions that are doing a lot of deletes.
You can go ahead and kill the SPID.
Also please run a DBCC CheckDB on the database.
Thank You,
Best Records,
SQLBuddy
September 17, 2010 at 6:36 am
hi thanks for your input, it was due to a huge snapshot that was done by the DBCC CheckDB that was still running, once the snapshot was deleted and sql restarted, the ghost cleanup was gone and my db is accessible again. 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply