Haunting the Ghost inside the SQL shell


What: The CPU counrte hitting the ceiling level of 100% …flat…. hanging..

When: Time when your applications, site, service becomes intermittent, timing out or stops responding completely

Why: The Ghost_counter inside MS SQL increasing rapidly

Who:  values of the ghost_record_count and version_ghost_record_count columns

Where: View and monitor it here >> (run this script)

SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'<DatabaseName>’), OBJECT_ID(N'<TableName>’), NULL, NULL , ‘DETAILED’);


*Check this not-so-good scenario from this script:


*Kill the ghost by this script:

dbcc traceon (661, -1)



Reference From Posts:


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s