Download the Tom's Hardware App from the App Store
The reference for current tech news
Yes No
Tom's Hardware > Forum > Storage > General Discussion > [Solved] SQL Storage IOPs

[Solved] SQL Storage IOPs

Forum Storage : General Discussion [Solved] SQL Storage IOPs

Related Content
You have searched for " [Solved] SQL Storage IOPs" . You might be interested in the following threads:

See more for " [Solved] SQL Storage IOPs"

Can't find your answer?
Ask!

Best answer from hugostiglitz.

General Discussion

|

Hard Drives

|

CD/DVD Drives

|

CD/DVD Writers

|

Optical Media

|

Flash Media

|

NAS/RAID

|

SSD

|

Buffalo Tech

|

QNAP

|

RunCore

Word :    Username :           
 
gklas   02-03-2012 at 03:06:12 AM

I am working on a pet project that involves parsing data files and processing them in a database(s). The amount of data I will be processing and storing is upwards of 3-4TBs. I am using SQL server 2008 R2 and will need to expand my storage requirements. I am interested in any advice on what type of storage I should use. I have considered building a new physical server with RAID 10 to house my sql server, but I have also considered buying a NAS server with 2x1GB NIC. My question is would it be sufficient for me to use a NAS server or should I just buy a new server and configure the RAID? I dont need the best IOPs, but I need it to be sufficient. I want to stress that this is for a pet project and would not be for enterprise deployment. I currently run a bare metal ESX 4 Update 2 VM server that houses my SQL Server and others with 4x500MB drives. I've look at purchasing the NETGEAR RNDU6000-100NAS Diskless ReadyNAS Ultra 6 and adding 2/3TB drives but I didnt know if this would be fast enough. Any advice?

Reply to gklas
Register or log in to remove.
hugostiglitz   02-03-2012 at 03:49:05 AM
Best answer

there is no NAS box that will be able to keep up with internal storage (in the physical machine)

even tho they will say gigibit ethernet the actual throu put is alot less.

i would definatly look at internal RAID solution, Via a hardware raid card. its going to be cheaper than the NAS box and run quicker.

------------------------------ 2700K @ 4.5 | Maximus IV Extreme-Z | 16gb RipjawX DDR3 1866mhz | 2x 2GB 5870's | Eyefinity @ 5760*1080 | 2x WD Black 1TB Raid 0 | EK&XSPC Water Cooled | Thermaltake 1200w PSU | Thermaltake Tai-Chi Case
No liability accepted or warranty given for advice
 Reply to hugostiglitz
NITROGENarcosis   02-03-2012 at 04:20:56 AM

Going with a NAS would be the better route if you intend to use the NAS with other systems as well. If it would only be used for the one server go for internal storage. A NAS with bonded gigabit adapters provides plenty of bandwidth for all but the very high end RAID setups. If going internal I defiantly agree with hugostiglitz recommendation for a hardware RAID card, as this provides a much better solution than builtin "fake raid" cards.

Reply to NITROGENarcosis
gklas   02-05-2012 at 04:48:32 PM

I appreciate the advice and insights. I think I will build a new box. I am not familiar with hardware raid controllers. Any suggestions on what I should look for in buying a hardware raid controller?

Reply to gklas
hugostiglitz   02-13-2012 at 01:56:48 AM

Adaptec has always been pretty good in my experience.

www.adaptec.com

Reply to hugostiglitz
Register or log in to remove.
Ask the community Add a reply
See all topics related to "SQL Storage IOPs"
Tom's Hardware > Forum > Storage > General Discussion > [Solved] SQL Storage IOPs
Go to:

There are 233 identified and unidentified users. To see the list of identified users, Click here.

Bestofmedia Forum ©
2000-2009 Bestofmedia Group
Page generated in 0.443 seconds
  • Ask the community now
  • Publish
Ad
Latest best answer
Audio through DVI
By amite, 61 days ago:

Recently, I replaced my older Asus GT9600 card with the newer Asus GTX560. Now, at first...

They won a badge
Join us in greeting them
How do I win badges?
Top experts
Become an expert The rank
Partners