SQL Server Performance

Measuring current I/O rate

Discussion in 'Performance Tuning for Hardware Configurations' started by dilan, Jun 26, 2007.

  1. dilan New Member

    Hi: I am planning on gathering some baseline information that can be used when evaluating options for future system upgrades etc.

    One of the things I have not been able to do is measure the current I/O rate of a particular volume. The numbers that can be used to create the input for a utility such as SQLIO. How do other gather this information?

    Thanks
  2. satya Moderator

    http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
    http://www.sql-server-performance.com/performance_monitor_counters.asp - perfmon counters
    http://www.sql-server-performance.com/performance_monitor_counters_io.asp - I/o
    http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/02/25/56.aspx

    Fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page