Size of an Index

• Robert Biddle

  SSC Eights!

  Points: 812

  More actions

  September 8, 2010 at 8:06 am

  #225935

  Is there any way to determine how many MB an index is either by querying system views or DMVs?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 8, 2010 at 8:27 am

  #1217982

  Yes.

  Query sys.dm_db_index_physical_stats. Look at the page_count column. A page is 8kb.

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737706

  More actions

  September 8, 2010 at 9:15 am

  #1218027

  http://msdn.microsoft.com/en-us/library/ms188917.aspx