version_ghost_record_count

  • Hi,

    I understand that [version_ghost_record_count] as retrieved from sys.dm_db_index_physical_stats shows the ghost records count sustained by a snapshot isolation transaction in an allocation unit.

    My question is this:

    I am seeing version ghost records in one of my databases but the database has Snapshot Isolation switched off. Is this possible?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • Sean Pearce (9/13/2013)


    I am seeing version ghost records in one of my databases but the database has Snapshot Isolation switched off. Is this possible?

    Yes. 😀

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks Gail. And the reason is?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • The snapshot isolations aren't the only things that use versioning. Off the top of my head online index rebuilds use versioning and triggers use the row version store. I know there's more things, but can't remember right now.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Do you think SCOPE_IDENTITY() could be one of the reasons?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • No.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply