May 19, 2011 at 7:10 pm
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
Thanks for posting this, it looks very informative.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy