determining sql iops usage

• dber

  Mr or Mrs. 500

  Points: 507

  More actions

  January 28, 2009 at 12:20 pm

  #383822

  hi there,

  how do you determine the average iops a sql 2005 is pushing. I've been asked to upgrade a box, but need to know if the current storage configuration is suitable, or if i need to add additional spindles.

  thanks in advance

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 28, 2009 at 12:44 pm

  #934093

  You can use the Windows Performance Monitor to look a disk IO and SQL Server IO.

• dber

  Mr or Mrs. 500

  Points: 507

  More actions

  January 28, 2009 at 1:12 pm

  #934110

  what are the specific counters?

  thanks!

• JohnMarks

  Ten Centuries

  Points: 1253

  More actions

  January 29, 2009 at 8:05 am

  #934704

  Disk Reads/Sec and Disk Writes/Sec = IOPS

  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx#Table3

  see table 3

• dber

  Mr or Mrs. 500

  Points: 507

  More actions

  January 29, 2009 at 11:15 am

  #934924

  thank you! appreciate it...