Post reply

Disk I/O Monitoring

  • September 7, 2010 at 6:21 am

    #237962

    HI

    Can anybody suggest me how to check the IOPS for mssql 2000 / 2005 / 2008 database so that we can go for disks required to fulfill the request of mssql?

    vrijesh

  • November 16, 2010 at 1:10 pm

    #1251561

    I don't fully understand your question, but if you are trying to determine the speed of your IO subsystem I suggest the free Microsoft tool SQLIO - search for "SQLIO Disk Subsystem Benchmark Tool" on Microsoft.com

  • November 16, 2010 at 2:10 pm

    #1251584

    See if this blog on "Handy Hardware Accessment Tools" will give you the answer you're looking for as far as tools are concerned.

    http://sqlserverperformance.wordpress.com/2010/11/15/handy-hardware-assessment-tools-for-sql-server/[/url]

    Or you can read this thread that discusses using sqlio to measure your disk I/O.

    http://www.sqlservercentral.com/Forums/Topic634266-146-1.aspx

    Hope this helps.

    😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply