Post reply

Interpreting SQLIOSim output

  • May 19, 2011 at 7:10 pm

    #251322

    Hi everyone,

    I ran this utility on a few of the H/Ds of a new server/SAN that we purchased. MS didn't have much info on what the output below means:

    ********** Final Summary for file G:\sqliosim.mdx **********

    File Attributes: Compression = No, Encryption = No, Sparse = No

    Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 64, Number of times IO throttled = 5571, IO request blocks = 8

    Reads = 17954, Scatter Reads = 29049, Writes = 635, Gather Writes = 27976, Total IO Time (ms) = 14793209

    DRIVE LEVEL: Sector size = 512, Cylinders = 240614, Media type = 12, Sectors per track = 63, Tracks per Cylinders = 255

    DRIVE LEVEL: Read cache enabled = No, Write cache enabled = No

    DRIVE LEVEL: Read count = 46994, Read time = -1621493078, Write count = 46199, Write time = -636700975, Idle time = 241309, Bytes read = 8646561792, Bytes written = 11022956544, Split IO Count = 0, Storage number = 5, Storage manager name = VOLMGR

    Closing file I:\sqliosim.mdx

    So I googled and landed on the following page and thought that it's really great and that I should share. Hope this helps:

    http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx

  • May 20, 2011 at 7:43 am

    #1327680

    Thanks for posting this, it looks very informative.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

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

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