locked
Measure IOPS RRS feed

  • Question

  • Is there any good way to measure IOPS on a current server that is running SQL Server? It seems like that SQLIO utility is more for bench marking a potential server that may be used as a SQL Server host.

    Are there any specific counters that I can add up to come up with current average IOPS of a sql server instance? Can adding the average of Disk Read/ Sec and Disk Write/Sec give me the average of IOPS?

    please advice.

    thanks


    SQL Pro

    Wednesday, April 25, 2012 12:53 PM

Answers

All replies