Overclock.net › Forums › Components › Hard Drives & Storage › SSD › Best SSD to host a 3GB database?
New Posts  All Forums:Forum Nav:

Best SSD to host a 3GB database?

post #1 of 10
Thread Starter 
I'm building a computer for a small office that will run MS SQL Server to support order management software.

The data file is not large, ~3GB, and there will be 5-10 users at any given time.

I was thinking about putting two 512GB Samsung 840 Pro in RAID1.

Your thoughts?
Edited by willis888 - 3/5/13 at 2:43pm
post #2 of 10
Why not just use 2 enterprise 64Gb drives and only allocate half of it so the rest can be used for increased storage speeds and better life especially if the database gets alot of small writes to it. And if it does get alot of small writes using a enterprise drive would help as some come with a back up capacitor so in case of power loss data does not get lost, unless its gonna be hooked up to a UPS.
 
Problem Solver
(15 items)
 
 
CPUMotherboardGraphicsRAM
intel Core i5 3570k 4.5ghz 1.200v - 0.000 offset  Gigabyte z77X-UP4 TH Beta Bios F11C with lastes... Sapphire 7950 3GB GSkill 2x8gb 2400mhz 11-13-13-31 T2 @ 10-13-13-... 
Hard DriveCoolingOSMonitor
Crucial M4 128GB SSD SATA 3.0 M4-CT128M4SSD1 Corsair H80 v2i AIO liquid cooling Windows 10 Professional x64 47 inch Samsung LCD HD TV 
PowerAudio
Corsair 850w modular stock 
CPUMotherboardGraphicsRAM
C2Q Q6600 GO @ 3.2ghz 1.28 Gigabyte P35 DS3-L Pencil modded Nvidia 9800 GT 512mb 2x1gb Gskill 1066 5-5-5-15 & 2x1gb Gskill Pi 80... 
Hard DriveHard DriveOptical DriveCooling
Crucial m4 CT128M4SSD1 128GB SSD - OS Drive Samsung HD103UJ & SJ 1 Terabyte HDD LG 22x DVD burner Arctic Freezer Pro 2  
OSMonitorPowerCase
Windows 7 Pro SP1 x64 HannsG 27.5" Widescreen Red thingy 750w Single rail old raidmax from 1st build beat to death 
  hide details  
Reply
 
Problem Solver
(15 items)
 
 
CPUMotherboardGraphicsRAM
intel Core i5 3570k 4.5ghz 1.200v - 0.000 offset  Gigabyte z77X-UP4 TH Beta Bios F11C with lastes... Sapphire 7950 3GB GSkill 2x8gb 2400mhz 11-13-13-31 T2 @ 10-13-13-... 
Hard DriveCoolingOSMonitor
Crucial M4 128GB SSD SATA 3.0 M4-CT128M4SSD1 Corsair H80 v2i AIO liquid cooling Windows 10 Professional x64 47 inch Samsung LCD HD TV 
PowerAudio
Corsair 850w modular stock 
CPUMotherboardGraphicsRAM
C2Q Q6600 GO @ 3.2ghz 1.28 Gigabyte P35 DS3-L Pencil modded Nvidia 9800 GT 512mb 2x1gb Gskill 1066 5-5-5-15 & 2x1gb Gskill Pi 80... 
Hard DriveHard DriveOptical DriveCooling
Crucial m4 CT128M4SSD1 128GB SSD - OS Drive Samsung HD103UJ & SJ 1 Terabyte HDD LG 22x DVD burner Arctic Freezer Pro 2  
OSMonitorPowerCase
Windows 7 Pro SP1 x64 HannsG 27.5" Widescreen Red thingy 750w Single rail old raidmax from 1st build beat to death 
  hide details  
Reply
post #3 of 10
Quote:
Originally Posted by terraprime View Post

Why not just use 2 enterprise 64Gb drives and only allocate half of it so the rest can be used for increased storage speeds and better life especially if the database gets alot of small writes to it. And if it does get alot of small writes using a enterprise drive would help as some come with a back up capacitor so in case of power loss data does not get lost, unless its gonna be hooked up to a UPS.
I'd go with this. You want something reliable more than anything. Speeds will be fast for database IO no matter what.
Xiggy
(10 items)
 
Crate
(10 items)
 
Thunder
(13 items)
 
CPUMotherboardGraphicsRAM
Intel Core i7 2600K ASRock z77 extreme 3 NVIDIA GeForce GTX 560 Ti Corsair  
Hard DriveHard DriveCoolingOS
Western Digital Western Digital Thermaltake Frio Windows 7 Home Premium 
PowerCase
OCZ Fatal1ty 750w Xigmatek Utgard Window 
CPUMotherboardGraphicsGraphics
AMD Opteron 180 MSI K8N SLI-F EVGA 9800GTX+ EVGA 9800GTX+ 
RAMHard DriveCoolingOS
DDR 200 OCZ Vertex 3 SSD Swiftech Polaris Linux Mint 14 
PowerCase
hec 650w Milk Crate 
CPUMotherboardGraphicsRAM
Phenom II x4 840 Asus m4a78lt-m VisionTek Radeon HD 5450 Corsair ValueSelect 1333 2GB 
Hard DriveOSMonitorKeyboard
160GB 5400rpm Windows 7 Home Premium Dell 19" Full Logitech 
PowerCaseMouse
535w Generic Thermaltake v4 Black Edition Logitech 
  hide details  
Reply
Xiggy
(10 items)
 
Crate
(10 items)
 
Thunder
(13 items)
 
CPUMotherboardGraphicsRAM
Intel Core i7 2600K ASRock z77 extreme 3 NVIDIA GeForce GTX 560 Ti Corsair  
Hard DriveHard DriveCoolingOS
Western Digital Western Digital Thermaltake Frio Windows 7 Home Premium 
PowerCase
OCZ Fatal1ty 750w Xigmatek Utgard Window 
CPUMotherboardGraphicsGraphics
AMD Opteron 180 MSI K8N SLI-F EVGA 9800GTX+ EVGA 9800GTX+ 
RAMHard DriveCoolingOS
DDR 200 OCZ Vertex 3 SSD Swiftech Polaris Linux Mint 14 
PowerCase
hec 650w Milk Crate 
CPUMotherboardGraphicsRAM
Phenom II x4 840 Asus m4a78lt-m VisionTek Radeon HD 5450 Corsair ValueSelect 1333 2GB 
Hard DriveOSMonitorKeyboard
160GB 5400rpm Windows 7 Home Premium Dell 19" Full Logitech 
PowerCaseMouse
535w Generic Thermaltake v4 Black Edition Logitech 
  hide details  
Reply
post #4 of 10
Cause I do remember reading a article from some where showing having more unallocated space on a SSD can help keep speeds up over long periods of time, while also increasing the life, but its mute point less you do a ton of writes to the drive for longer drive life.
 
Problem Solver
(15 items)
 
 
CPUMotherboardGraphicsRAM
intel Core i5 3570k 4.5ghz 1.200v - 0.000 offset  Gigabyte z77X-UP4 TH Beta Bios F11C with lastes... Sapphire 7950 3GB GSkill 2x8gb 2400mhz 11-13-13-31 T2 @ 10-13-13-... 
Hard DriveCoolingOSMonitor
Crucial M4 128GB SSD SATA 3.0 M4-CT128M4SSD1 Corsair H80 v2i AIO liquid cooling Windows 10 Professional x64 47 inch Samsung LCD HD TV 
PowerAudio
Corsair 850w modular stock 
CPUMotherboardGraphicsRAM
C2Q Q6600 GO @ 3.2ghz 1.28 Gigabyte P35 DS3-L Pencil modded Nvidia 9800 GT 512mb 2x1gb Gskill 1066 5-5-5-15 & 2x1gb Gskill Pi 80... 
Hard DriveHard DriveOptical DriveCooling
Crucial m4 CT128M4SSD1 128GB SSD - OS Drive Samsung HD103UJ & SJ 1 Terabyte HDD LG 22x DVD burner Arctic Freezer Pro 2  
OSMonitorPowerCase
Windows 7 Pro SP1 x64 HannsG 27.5" Widescreen Red thingy 750w Single rail old raidmax from 1st build beat to death 
  hide details  
Reply
 
Problem Solver
(15 items)
 
 
CPUMotherboardGraphicsRAM
intel Core i5 3570k 4.5ghz 1.200v - 0.000 offset  Gigabyte z77X-UP4 TH Beta Bios F11C with lastes... Sapphire 7950 3GB GSkill 2x8gb 2400mhz 11-13-13-31 T2 @ 10-13-13-... 
Hard DriveCoolingOSMonitor
Crucial M4 128GB SSD SATA 3.0 M4-CT128M4SSD1 Corsair H80 v2i AIO liquid cooling Windows 10 Professional x64 47 inch Samsung LCD HD TV 
PowerAudio
Corsair 850w modular stock 
CPUMotherboardGraphicsRAM
C2Q Q6600 GO @ 3.2ghz 1.28 Gigabyte P35 DS3-L Pencil modded Nvidia 9800 GT 512mb 2x1gb Gskill 1066 5-5-5-15 & 2x1gb Gskill Pi 80... 
Hard DriveHard DriveOptical DriveCooling
Crucial m4 CT128M4SSD1 128GB SSD - OS Drive Samsung HD103UJ & SJ 1 Terabyte HDD LG 22x DVD burner Arctic Freezer Pro 2  
OSMonitorPowerCase
Windows 7 Pro SP1 x64 HannsG 27.5" Widescreen Red thingy 750w Single rail old raidmax from 1st build beat to death 
  hide details  
Reply
post #5 of 10
why would you need 500GB for 3GB of data? o_O
post #6 of 10
Quote:
Originally Posted by Sean Webster View Post

why would you need 500GB for 3GB of data? o_O

Heavy writes go to databases right? Like Amazon's database servers would have massive amounts of I/O on them compared to 1,000 of us OCNers
post #7 of 10
Thread Starter 
The larger drive was for better IOPS and wear leveling. The file is small, but it's constantly being written to and changed. I'm less concerned about having lots of extra space for wear leveling with enterprise nand.
Quote:
Originally Posted by terraprime View Post

Why not just use 2 enterprise 64Gb drives and only allocate half of it so the rest can be used for increased storage speeds and better life especially if the database gets alot of small writes to it. And if it does get alot of small writes using a enterprise drive would help as some come with a back up capacitor so in case of power loss data does not get lost, unless its gonna be hooked up to a UPS.

That's good information. Thank you.

I have not been watching enterprise ssd benchmarks. Could you make any recommendations about what models to look for? I've got my eye on the 100GB Intel 710 - it seems like it might not be as fast as a Samsung 840, but the capacitor backup is critical.
Edited by willis888 - 3/5/13 at 4:04pm
post #8 of 10
Quote:
Originally Posted by FlashFir View Post

Quote:
Originally Posted by Sean Webster View Post

why would you need 500GB for 3GB of data? o_O

Heavy writes go to databases right? Like Amazon's database servers would have massive amounts of I/O on them compared to 1,000 of us OCNers
It depends on the actual workload of the specific use. Just cause something is a data base doesn't mean intensive writing all the time. And 500GB is way way more than enough OP for the 3GB data file if there are heavy writes.
Quote:
Originally Posted by willis888 View Post

Quote:
Originally Posted by terraprime View Post

Why not just use 2 enterprise 64Gb drives and only allocate half of it so the rest can be used for increased storage speeds and better life especially if the database gets alot of small writes to it. And if it does get alot of small writes using a enterprise drive would help as some come with a back up capacitor so in case of power loss data does not get lost, unless its gonna be hooked up to a UPS.

That's good information. Thank you.

I have not been watching enterprise ssd benchmarks. Could you make any recommendations about what models to look for? I've got my eye on the 100GB Intel 710.
How about Intel's newest?

https://www.google.com/shopping/product/5739983980989367729?hl=en&client=firefox-a&hs=BYi&rls=org.mozilla:en-US:official&sclient=psy-ab&q=intel%20dc%20s3700%20ssd%20100gb&oq=intel%20dc%20s3700%20ssd%20100gb&gs_l=serp.3...4409.6453.5.6613.6.6.0.0.0.0.132.599.3j3.6.0...0.0...1c.1.5.psy-ab.FGa_owiWAjE&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&bvm=bv.43287494,d.eWU&biw=1920&bih=951&sa=X&ei=uIc2UaTFG4Oq8AS2oYGQCg&ved=0CEwQ8wIwAA&prds=scoring:tp
post #9 of 10
Back up back up back up. For a database, the most important thing is having a back up that you can recover from if anything goes wrong. RAID 1 is nice, but be sure you are actually take database backup properly.

In case both of your SSDs gone poof at the same time, you should check with your manager/boss on what type of data loss is acceptable.
Red and Black
(15 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 6700k Asus Maximus VIII Hero Asus Strix GTX970 16GB Corsair Vengeance DDR4 3200 
Hard DriveHard DriveCoolingMonitor
500gb Samsung 850 EVO 640gb WD Caviar Black TT Silver Arrow Dell U2312M 
PowerCaseMouse
Seasonic X-750 CM 690 II Logitech G502 Proteus Core 
  hide details  
Reply
Red and Black
(15 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 6700k Asus Maximus VIII Hero Asus Strix GTX970 16GB Corsair Vengeance DDR4 3200 
Hard DriveHard DriveCoolingMonitor
500gb Samsung 850 EVO 640gb WD Caviar Black TT Silver Arrow Dell U2312M 
PowerCaseMouse
Seasonic X-750 CM 690 II Logitech G502 Proteus Core 
  hide details  
Reply
post #10 of 10
Thread Starter 

That's the one. TYVM.
Quote:
Originally Posted by arctia View Post

Back up back up back up. For a database, the most important thing is having a back up that you can recover from if anything goes wrong. RAID 1 is nice, but be sure you are actually take database backup properly.

In case both of your SSDs gone poof at the same time, you should check with your manager/boss on what type of data loss is acceptable.

It's on me to set the policy about how much data loss is acceptable. When I inherited this responsibility, all our data was in a single off the shelf NAS (4x 500GB disks in 2x RAID1 arrays), data on one RAID1, and backups on the other RAID1 in the same NAS. It looked like it was set up for daily backups, but the NAS software must have been buggy because it was only creating a backup once per week.

Since then, I've built 3 file servers, designed a more reasonable backup schedule for them, and got some help installing FreeBSD.

There's a fileserver in our office that keeps hourly, daily, weekly, and monthly backups of the database, and provides private storage for personal projects. Five 3TB Greens in RAID6.
There's a second fileserver in the next building over that makes backups daily, weekly, and monthly as our off-site backup, and mirrors public and private projects data. Also five 3TB Greens in RAID6.
The data file itself lives on a third server which also provides public storage for collaborative tasks. RAID10 + hot spare using five 640GB Blacks on an Adaptec RAID card w/ 512MB of RAM (once upon a time, our data file was less than 512MB).

Some time ago, I chose to create a backup once per hour during business hours. The way I see it, there is a balance to maintain between frequency of backups and the performance hit taken while the backup is happening. Once I've got the SSD's in the third server, I'll see how long it takes to backup the datafile from the SSD to the RAID10, and consider more frequent backups based on the results.
Edited by willis888 - 3/5/13 at 9:06pm
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: SSD
Overclock.net › Forums › Components › Hard Drives & Storage › SSD › Best SSD to host a 3GB database?