October 1, 2011 at 7:27 pm
I need to identify the standard IO benchmark of my system. My thoughts are:
1. Use avg read/writes Per sec counter to identify rough benchmarknod what system is actually doing.
2. Use sqlio or some other tool to identify what the disk subsystem is actually capable of.
Am I being too simplistic in my approach? Am I missing something?
October 2, 2011 at 6:37 am
SQLIO is a great tool for measuring the IO performance of the system. It's not hard to set up and the tests will tell you what you need to know about how much load your disks are capable of supporting. One issue with it, when performing the tests with any kind of compression involved, since SQLIO writes a basically empty set to the database, compression performance will be ridiculously skewed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2011 at 7:09 am
What type of IO disk subsystem do you have? If it's SAN then your SAN Administrator might be able to assist you with valuable metrics while running SQLIO or sample loads.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply