Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

All Questions

Filter by
Sorted by
Tagged with
2
votes
1answer
203 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 ...
0
votes
1answer
350 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
809 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
310 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
581 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
283 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
840 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
953 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. ...