Post reply

pages and extent information combined

  • August 9, 2011 at 2:44 am

    #255125

    Hi All,

    Is there any query which can give us information about which page of table belongs to these extents.

    Thanks in Advance.

  • August 9, 2011 at 3:11 am

    #1365690

    Remember an extent is just a contiguous set of 8 pages aligned on a 64kb boundary. Hence if you have a way to identify the pages (like DBCC IND) you can work the extents out yourself.

    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