SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Disk Subsystem Benchmark		  Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

graz
Chief SQLTeam Crack Dealer

USA
4128 Posts
Posted - 05/06/2002 :  10:31:13  Show Profile  Visit graz's Homepage
I'm curious if anyone out there has done any benchmarking of a disk subsystem. Are there any good tools that measure disk throughput? Is there any good way to relate that to SQL Server performance?

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

MichaelP
Jedi Yak

USA
2489 Posts
Posted - 05/06/2002 :  11:55:38  Show Profile  Visit MichaelP's Homepage
As far as subsystem to performance, I think you have to look at what you do more of (# of reads vs # of writes) and then you can determine how to setup your RAID array. Other than that, get the fastest drives, with the most cache, and a RAID controller with as much cache as you can, and MAKE SURE your RAID controller has abattery backed up cache.

Take a look at this when making your RAID configuration decision.
http://www.bolthole.com/uuala/RAID.html

I've not done any number crunching etc, but I think that Ultra2 SCSI (80MB/sec) drives at about 18-36GB's per drive is about the best bang for buck currently.

Michael
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000