How to benchmark my IO and which tool is the best one to go

  • Hi,

    We want to know the max capacity and the current running capcity of the SAN drives.Please suggest me how to move forward on this.There are some tools like sqlio,sqlioism,iometer ,out of these tools which one is better to choose.

    Thanks,

    Vamsy

  • .

  • have you checked by putting proper counter in perfmon(performance monitor).

    You can get these details there as well.

    If you interested in tool, then I use quest PA/Spotlight and they are really one of the best.

    ----------
    Ashish

  • SQLIO doesn't test SQL server IO exclusively. It's better for all round IO testing and pushing the SAN to find it's limits. Check the Microsoft documentation that comes with SQLIO!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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