Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

12 questions
15
votes
2 answers

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 Tables are stored in different filegroups with 3-4…
Oleg Dok
  • 3,407
  • 26
  • 29
10
votes
2 answers

Understanding why ghost version records in SQL server 2019 exists across application server restarts?

Please bear with me as I'm not a DBA nor am I a SQL server expert. We added an index to a table and noticed after about a day or so, the storage for the index grew to around 200 MB. The reason for this, we surmised, is due to the high number of…
Dark Star1
  • 271
  • 2
  • 11
10
votes
1 answer

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 at ~7.5M records added and removed but with the…
Ste Bov
  • 2,101
  • 1
  • 14
  • 19
4
votes
1 answer

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 have many, many SharePoint dbs where the logfile size…
DiamondBeezer
  • 159
  • 2
  • 11
3
votes
2 answers

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. Obvious solution would be: BEGIN TRAN ALTER TABLE…
user4605
3
votes
1 answer

Remove version ghost records of allocation type LOB_DATA without restarting the service or failing over

A database that is part of a SQL Server Always Availability Group with both synchronous and asynchronous readable secondaries that are being used to scale out read-only workloads is experiencing a build up of version ghost records of allocation type…
afreeman
  • 31
  • 1
3
votes
1 answer

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 flush rate was high, and write/sec was close to…
tong
  • 31
  • 4
3
votes
2 answers

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 usage (Real SQL Server Usage double checked with…
J1mmy
  • 550
  • 1
  • 8
  • 21
2
votes
1 answer

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 (nolock) on ss.some_column= oo.some_other_column SSMS…
user4659
2
votes
1 answer

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 Database and always was at the same value (Around…
J1mmy
  • 550
  • 1
  • 8
  • 21
1
vote
0 answers

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, from 75% to 99%, these aren't bursts but sustained…
kaitlyn
  • 593
  • 2
  • 7
  • 15
0
votes
1 answer

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 were closed correctly. The sys.sysdercv system…
Jeff Lehn
  • 31
  • 4