Post reply

Does list of page ids allocated for a table change during index rebuilds?

  • July 16, 2015 at 9:10 am

    #302365

    We noticed a deadlock 3-4 weeks ago on a table (table1) and deadlock graph was captured.

    When I am analyzing the deadlock graph, page number using DBCC PAGE, I am getting the object id for a different table (table2). But deadlock graph shows the name of the object as table1.

    Is it possible that subsequent defragmentation of indexes would have caused the respective page id to got re-allocated to a different table? I checked the deadlock graph lately only after 3-4 weeks.

    Thanks.

  • July 16, 2015 at 9:17 am

    #1813020

    Yes.

    Index rebuild creates a new index and then drops the old one.

    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 2 posts - 1 through 1 (of 1 total)

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