title: Sql server table usage statistics
body: <p>I want to find out which tables in the database are most heavily used (I mean read/write Bytes/Table Size ratio) or IO / Table size ratio. To decide which tables to place on faster discs and which on slower ones. Any ideas?</p>
  
  <p>I tried make use of dm_db_index_usage_stats<br>
  But how to find out how many IO are under single seek/scan?</p>
  
  <p>Thank you in advance.</p>