Which page record,extents are currently used as mixed..

• mohan.bndr

  SSCrazy

  Points: 2360

  More actions

  September 2, 2013 at 6:33 am

  #276755

  Hi All,

  I would like to know here about pages ... as Which pages record, which extents are currently used as mixed extents and have at least one unused page.. Can any one please suggest...

  Thanks in advance

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 2, 2013 at 7:01 am

  #1646741

  That would be the SGAM page.

  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

• Snigdha Vartak

  Default port

  Points: 1486

  More actions

  September 5, 2013 at 2:08 pm

  #1647840

  Article below explains this in simple terms:

  http://www.practicalsqldba.com/2012/09/sql-server-understanding-gam-and-sgam.html