<div>
<div class="content wysiwyg-content">
I am trying to configure a new computer (from Dell) for my database guy. &nbsp;He has at least 2 full-blown SQL instances on his desktop. &nbsp;His current machine is a little over 3 years old. &nbsp;It has 2 10k RPM SATA hard drives (Western Digital-EX, if that makes any difference) in RAID 0. &nbsp;This new one that we are getting has a better processor and better ram, but I figure that won't matter TOO much if his hard drives were his bottle neck in the first place (because he does so much reading and writing). &nbsp;So my question is: If I'm running two drives in RAID 0, would I really see that much of a performance increase going with SAS 10k over SATA 10k?<br />
<br />
And just out of curiosity, what about SAS 15k over SATA 10k?<br />
<br />
Thanks.
</div>
</div>


I am trying to configure a new computer (from Dell) for my database guy.  He has at least 2 full-blown SQL instances on his desktop.  His current machine is a little over 3 years old.  It has 2 10k RPM SATA hard drives (Western Digital-EX, if that makes any difference) in RAID 0.  This new one that we are getting has a better processor and better ram, but I figure that won't matter TOO much if his hard drives were his bottle neck in the first place (because he does so much reading and writing).  So my question is: If I'm running two drives in RAID 0, would I really see that much of a performance increase going with SAS 10k over SATA 10k?

And just out of curiosity, what about SAS 15k over SATA 10k?

Thanks.

SAS vs SATA in RAID 0?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Hardware includes cell phones and other digital living devices, tablets, computers, servers, peripherals and components, printers and scanners, gaming consoles, networking hardware such as routers, hubs, switches and modems, storage devices and security equipment such as firewalls and other appliances.

Hardware

WD, a Western Digital company, is a long-time innovator and storage industry leader. As a storage technology pacesetter, the company produces reliable, high-performance hard disk drives and solid state drives. These drives are deployed by OEMs and integrators in desktop and mobile computers, enterprise computing systems, embedded systems and consumer electronics applications, as well as by the company in providing its own storage products. WD’s leading storage devices and systems, networking products, media players and software solutions empower people around the world to easily save, store, protect, share and experience their content on multiple devices. WD was established in 1970 and is headquartered in Irvine, Calif. For more information, please visit the company’s website at www.wd.com.