Database & Disk Deck
I have posted the deck I give at conferences on database and disk drives. It's a "shorter" deck (ie. One hour talk), instead of the larger deck I sometimes use that covers 4 hours.
A short abstract:
It focuses on how to create a scalable database solution on everything from direct attached SCSI to SANs. The deck covers perfmon counters, partition alignment, SQL IO performance testing, proper number of files for space management, etc...
www.computationpress.com
posted by Frank McBath at 4:30 PM
1 Comments:
3ms response time? what is your MaxOutstandingIO set to? 1?
Even with 8 sas 15k disks, I cannot get the disk response time down below 50ms without reducing the MaxOutstandingIO<=32 in sqliosim.
Post a Comment
<< Home