Determine Read/Write Frequency

• mceventphoto

  Ten Centuries

  Points: 1299

  More actions

  October 6, 2015 at 2:16 pm

  #303922

  How do I determine the read/write frequency on a database table? I am trying to do this on a 2012 and 2008 R2 servers.

  Thanks,

  MC

• g.britton

  SSChampion

  Points: 13863

  More actions

  October 6, 2015 at 2:26 pm

  #1831862

  Perfmon to the rescue!

  Good writeup here: Measuring Disk IO performance for SQL Servers

  Gerald Britton, Pluralsight courses

• mceventphoto

  Ten Centuries

  Points: 1299

  More actions

  October 6, 2015 at 3:10 pm

  #1831867

  Thanks for the information. I also found what I was looking for in the Performance Dashboard IO report.

  Thanks,

  MC