• TheSQLGuru (4/25/2012)


    GilaMonster (4/25/2012)


    TheSQLGuru (4/25/2012)


    SQLIOSIM is the tool to use to validate that an IO subsystem will properly handle SQL Server IO-style workloads.

    But SQL needs to be stopped when running that. The aim is to validate the IO subsystem, nor slaughter it.

    I thought he/she said they wanted to know if the IO subsystem had problems with SQL Server data that was causing problems. SQLIOSIM is a/the way to validate that.

    Sure, but they can't stop SQL Server without justification (proof of IO problems). Vicious circle.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass