The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [ghost-cleanup]

The SQL Server ghost cleanup task is responsible for removing data logically marked as deleted, but not yet physically removed from the target data structure.

Filter by
Sorted by
Tagged with
2
votes
1answer
199 views

What is the “shrinkd” in SQL Server logs?

I found lots of ShrinkD, ghostcleanuptask, and BTree Split/Shrink in my SQL Server logs. At the time of these logged events, the performance counters showed that lazy writes were very slow, the log ...
9
votes
1answer
1k views

Ghost Cleanup settings

I'm running a high transactional database (~175k transactions / Minute on average, almost 9M records per hour added and removed) Up till recently this hasn't been too much of an issue as we've been ...
0
votes
1answer
344 views

Potential corruption in sys.sysdercv, latch errors from ghost cleanup process

We're running SQL Enterprise 2016 (13.0.4411). I have a database that was using service broker to handle some workflow, long story short, it was designed incorrectly and none of the conversations ...
1
vote
1answer
789 views

Transaction terminated running SELECT on secondary AG group

Using SQL Server 2016, Always-On Running a simple SELECT on a table within a secondary Availability Group. select distinct some_column from some_table oo (nolock) inner join some_other_ ss (...
2
votes
1answer
293 views

GHOST_CLEANUP not freeing up space on SQL Server Availability Group

Had a problem in my SQL Server Cluster for 2 weeks, I had the GHOST_CLEANUP process running 24/7 never stopping even if the users were doing nothing. I was checking the "Free Space" parameter in the ...
3
votes
2answers
562 views

GHOST_CLEANUP Lots of IO and CPU Usage

I have been trying to troubleshoot an issue I have detected on a UAT SQL Server, there is some resource usage even if the server is not being used... On Activity monitor I have an average of 5% CPU ...
3
votes
1answer
276 views

SQL Server High Availability and Sharepoint - log file grows when no database activity

Just started as a dba with a company running SQL Server 2012 High Availability and SharePoint. Short description: Database with no user activity still has growing log file. Long description: They ...
2
votes
0answers
836 views

Ghost Cleanup process has high CPU usage in SQL Server 2012 SP1

Has anyone encountered this? We are using SQL Server 2012 Enterprise Edition with SP1. During a time of low/no activity, I noticed the Ghost Cleanup process is utilizing CPU at a very high rate, ...
15
votes
2answers
8k views

SQL Server Frozen Ghost Cleanup workaround needed

I have several tables with amount of rows between 5M and 1.5G Each table has its BLOB field, which size varies from 100 bytes to 30 MBytes and which is stored as 'large value types out of row' = ON ...
3
votes
2answers
951 views

High CPU usage by GHOST CLEANUP after DROP FK and DELETE

I am trying to replace data in table referenced by FKs in other tables on SQL Server. There are more than 1M rows in both referenced and referencing table and I want to make the replacement atomic. ...