|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
 Posted - 03/09/2013 : 05:35:11
|
Ghost_record_count is count of Rows in the leaf level of an index that has been marked for deletion, but has not yet been deleted by the database engine.
KILL/ROLLBACK - If a rollback is in progress for a specific SPID, the cmd column in the sp_who result set for that SPID will indicate KILLED/ROLLBACK.
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
 |
|
Ghost_record_count vs KILL/ROLLBACK
