Post reply

version_ghost_record_count

  • September 13, 2013 at 4:25 am

    #283197

    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]

  • September 13, 2013 at 5:06 am

    #1650014

    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

  • September 13, 2013 at 5:13 am

    #1650017

    Thanks Gail. And the reason is?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • September 13, 2013 at 5:19 am

    #1650019

    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

  • September 13, 2013 at 6:33 am

    #1650030

    Do you think SCOPE_IDENTITY() could be one of the reasons?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • September 13, 2013 at 7:02 am

    #1650039

    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