A way to measure the I/O per table and index in SQLServer 2005

• Jose Julio Mota Duarte

  Old Hand

  Points: 392

  More actions

  January 27, 2009 at 10:56 am

  #196479

  Good afternoon

  someone knows a way to measure the I / O per table and index in SQLServer 2005?

  Compliments

  José Júlio Duarte

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 27, 2009 at 11:13 am

  #933401

  have a look at sys.dm_db_index_operational_stats

  
  * Noel