笔记268 如何查看SQL 表里的幽灵记录 ghostrecord 2013-5-9

笔记268 如何查看SQL 表里的幽灵记录 ghostrecord 2013-5-9

--如何查看SQL 表里的幽灵记录 ghostrecord 2013-5-9
SELECT  DB_NAME(database_id) AS '数据库', OBJECT_NAME(object_id), ghost_record_count,
        version_ghost_record_count
FROM    sys.dm_db_index_physical_stats(DB_ID(N'GPOSDB'),
                                       OBJECT_ID(N'dbo.CT_FuelingData'), NULL, NULL,
                                       'DETAILED');
                                      
--描述：The Ghost record count is the row count in the index leaf level marked for deletion,
-- but not yet deleted by the database engine Ghost_record_count is the ghost record count awaiting removal by the ghost cleanup task in the allocation unit.
--  Version_Ghost_record_count is the ghost records count
--sustained by a snapshot isolation transaction in an allocation unit.