Interpreting SQLIOSim output

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  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

• WayneS

  SSC Guru

  Points: 95461

  More actions

  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