Do you have ghosts in your database. Take a look at this article from Jason Brimhall to learn some techniques for finding these scary issues in your database instances. In his series of articles, you might find some interesting tips to improve your database environment.
For this article, I had planned to discuss another undocumented method to look into the ghost records and their existence based on what was said on an msdn blog. But after a lot of research, testing and finally reaching out to Paul Randal, I determined that won’t work. So that idea was flushed all the way to Tartarus.
Let it be made very clear that DBTABLE does not offer a means to see the ghosts. Paul and I agree that the other article that mentioned DBTABLE really should have been referring to DBCC Page instead.
Despite flushing the idea to Tartarus, it was not a fruitless dive. It just was meaningless for the purpose of showing ghosts via that DBCC command. I still gained value from the dive!!
All of that said, the remainder of the plan still applies and it should be fun.
Really, at this point what is there that hasn’t been done about the ghosts? Well, if you are well tuned to these apparitions, you may have received the urge to explore them with Extended Events – sometimes called XE for short.