Posted - 04/02/2013 : 01:44:48
| Hi Experts,
We have observed that "Ghost Cleanup" records are not getting cleaned up and ghost record count keeps on increasing when querying sys.dm_db_index_physical_stats.
After a SQL server reboot the "Ghost_record_count" came down, dramatically.
Could you please suggest in which scenario "ghost_record_count" will not clean up automatically, as server reboot is not the best possible suggestion.
Please suggest us,
1. In what scenarion "ghost_record_count" increases. (Our assumption, this record count will increase if any record got deleted from a table which does not contain Cluster Index)
2. How automatically "ghost_record_count" decreases automatically.
Thanks for your help!