SQL Server Frozen Ghost Cleanup workaround needed

Finally, MS has recognized the issue as a bug: http://support.microsoft.com/kb/2622823

Briefly: It is fixed in

• Sql Server 2008 SP3 CU4
• Sql Server 2008 R2 CU10
• Sql Server 2008 R2 SP1 CU4

In Sql Server 2012 SP1 I'm not experiencing the issue for more than year of runtime.

This is the kind of question that should go to CSS so that they can work the issue with you. You probably have software assurance and a support contract. If you don't a few hundred bucks shouldn't be that big a deal if restarting the instance costs you thousands of dollars per hour.

Have you tried allowing the database to close and then be brought online? This will cause crash recovery to run and may kick the ghost cleanup.

Are you writing to the table frequently? By frequently I mean all the time?

As to MSKB 932115 are you seeing the ghost records being left only in all files, or is it cleaning up the first file in the file group?

Why the use of -T1117 and instant file init?