Overclock.net › Forums › Specialty Builds › Servers › Hardware for a quickbooks server
New Posts  All Forums:Forum Nav:

Hardware for a quickbooks server - Page 2

post #11 of 20
Quote:
Originally Posted by tycoonbob View Post

If you are building a box for a server-designed piece of software, then chances are a server CPU will perform better (i.e., Xeon or Opteron). Consumer SSDs are not good for database based applications, as all the random read and writes can really hurt performance. Not to mention, if your own drive dies...you loose everything. You need some kind of raid or a reliable controller; Raid 5, 6 or 10. If you go SSD, I say enterprise SSDs...but you are probably better of getting 10K or 15K RPM SAS drives. Lastly, another great benefit of a real server is dual gigabit links. Set them up in LACP for reliability (fail over) and increased performance (when multiple connections to the server exist).
Just sayin...

Note, the software explicity does not require any "server" or enterprise level requirements.

Consumer SSDs are fine for database applications. Virtually all use about the same controllers with some minor tweaks. They are still better than HDDs. The major difference with consumer vs enterprise is use of SLC or eMLC. However, a consumer SSD with a lots of reserved space can be adequate.

You can get teamed NICs on any machine... just plug in the right card(s).

Quote:
Originally Posted by Blindsay View Post

yeah I was thinking of doing 2x of the Samsung 840 pros in RAID1 and then set them up with an external backup solution as well, arching is a good idea though in case they had to rollback to a certain date.
I am going there this week to look at their current setup. I saw those requirements but I know sometimes the suggested requirements can leave something to be desired performance wise haha.
Thanks
Ask them to run and email you the output of msinfo32?
Edited by DuckieHo - 12/10/12 at 9:11am
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #12 of 20
Thread Starter 
Quote:
Originally Posted by DuckieHo View Post

Note, the software explicity does not require any "server" or enterprise level requirements.
Consumer SSDs are fine for database applications. Virtually all use about the same controllers with some minor tweaks. They are still better than HDDs. The major difference with consumer vs enterprise is use of SLC or eMLC. However, a consumer SSD with a lots of reserved space can be adequate.
You can get teamed NICs on any machine... just plug in the right card(s).
Ask them to run and email you the output of msinfo32?

on the topic of reserved space, if I wanted to force them to have extra reserved space could I just format the drives to smaller than their full capacity?
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
post #13 of 20
Quote:
Originally Posted by Blindsay View Post

on the topic of reserved space, if I wanted to force them to have extra reserved space could I just format the drives to smaller than their full capacity?

Yup exactly.

it improves consistency as well: http://www.anandtech.com/show/6489/playing-with-op
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #14 of 20
Thread Starter 
Quote:
Originally Posted by DuckieHo View Post

Yup exactly.
it improves consistency as well: http://www.anandtech.com/show/6489/playing-with-op

Cool article, Thank you. 192GB looks like a good number
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
post #15 of 20
Quote:
Originally Posted by Blindsay View Post

Cool article, Thank you. 192GB looks like a good number

Good number based on what though? wink.gif


Look at my #8 in my sig...
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #16 of 20
Thread Starter 
Quote:
Originally Posted by DuckieHo View Post

Good number based on what though? wink.gif
Look at my #8 in my sig...


lol, I just meant good for the performance of that particular drive

nice ninja edit by the way tongue.gif
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
post #17 of 20
We run Quick Books at work with 5 users M-F. We have 1 Super Micro Quad Core Xeon box with WD Green's in RAID 1 on a gigabit network. Quick Books is just a bit sluggish and not as quick as it should be. My guess those WD Greens are the bottleneck. I haven't checked the network utilization, but i'm guessing that's not the problem, it's the hard drives that's slow. Also could be that Quick Books is bloated garbage....
Sandy Maximized
(16 items)
 
 
FreeNAS Server
(13 items)
 
CPUMotherboardGraphicsRAM
Core i7 2600K@ 4.6GHz 1.38 Asus Maximus IV Extreme MSI GAMING X 8G GTX 1070 Patriot Viper 3 16GB 1600MHz Cas 9 
Hard DriveHard DriveOptical DriveCooling
Samsung 850 Pro 256GB  Western Digital RE4 3TB (Data) LG DVD-RW Corsair H100 Push / Pull 
OSMonitorKeyboardPower
Windows 10 x64 Acer 27" 1920 x 1080 LED LCD Corsair Vengeance K60 Keyboard with Cherry® MX ... Corsair Pro Series HX850 
CaseMouseMouse PadAudio
NZXT Switch 810 Glossy Black Razer DeathAdder 3.5G Corsair Vengeance MM400 Mouse Mat Realtek ALC889 
CPUMotherboardRAMHard Drive
Core 2 Duo 6420 2.13GHz Super Micro PDSML-LN2+ 4GB DDR2 5300E 150GB Western Digital 10k Velociraptor 
Hard DriveOSCase
150GB Western Digital 10k Velociraptor PFsense FreeBSD 1U Rack Mount Half Depth 
CPUMotherboardGraphicsRAM
Core 2 Duo 6400 2.13GHz GIGABYTE GA-G41MT-S2PT LGA775 Onboard Gskill 8GB DDR3 1333 
Hard DriveHard DriveHard DriveHard Drive
Western Digital Red 2TB WD20EFRX ZFS Mirror Western Digital Red 2TB WD20EFRX ZFS Mirror Hitachi HDT721010SLA360 1TB ZFS Mirror Hitachi HDT721010SLA360 1TB ZFS Mirror 
CoolingOSPowerCase
Enermax Magma 120mm Fan FreeNAS 8.3.0 x64 Cooler Master Silent Pro M600 Some old Velocity Micro / Lian Li  
Other
Intel PRO / 1000 MT Dual Gigabit Nic 
  hide details  
Reply
Sandy Maximized
(16 items)
 
 
FreeNAS Server
(13 items)
 
CPUMotherboardGraphicsRAM
Core i7 2600K@ 4.6GHz 1.38 Asus Maximus IV Extreme MSI GAMING X 8G GTX 1070 Patriot Viper 3 16GB 1600MHz Cas 9 
Hard DriveHard DriveOptical DriveCooling
Samsung 850 Pro 256GB  Western Digital RE4 3TB (Data) LG DVD-RW Corsair H100 Push / Pull 
OSMonitorKeyboardPower
Windows 10 x64 Acer 27" 1920 x 1080 LED LCD Corsair Vengeance K60 Keyboard with Cherry® MX ... Corsair Pro Series HX850 
CaseMouseMouse PadAudio
NZXT Switch 810 Glossy Black Razer DeathAdder 3.5G Corsair Vengeance MM400 Mouse Mat Realtek ALC889 
CPUMotherboardRAMHard Drive
Core 2 Duo 6420 2.13GHz Super Micro PDSML-LN2+ 4GB DDR2 5300E 150GB Western Digital 10k Velociraptor 
Hard DriveOSCase
150GB Western Digital 10k Velociraptor PFsense FreeBSD 1U Rack Mount Half Depth 
CPUMotherboardGraphicsRAM
Core 2 Duo 6400 2.13GHz GIGABYTE GA-G41MT-S2PT LGA775 Onboard Gskill 8GB DDR3 1333 
Hard DriveHard DriveHard DriveHard Drive
Western Digital Red 2TB WD20EFRX ZFS Mirror Western Digital Red 2TB WD20EFRX ZFS Mirror Hitachi HDT721010SLA360 1TB ZFS Mirror Hitachi HDT721010SLA360 1TB ZFS Mirror 
CoolingOSPowerCase
Enermax Magma 120mm Fan FreeNAS 8.3.0 x64 Cooler Master Silent Pro M600 Some old Velocity Micro / Lian Li  
Other
Intel PRO / 1000 MT Dual Gigabit Nic 
  hide details  
Reply
post #18 of 20
I hate when i go into new clients and they have consumer grade components. There business is basically run off the server and if the data is important then get server grade components.
Intel Xeon E3 1230 4core w/HT
at least 16gb ECC Ram
Adaptec 2405 Raid Controller
(2) 15K SAS drives either 300gb or 600gb depending on storage needs, will client workstations have folder redirects?
Supermicro X9SCM

Think about future growth of the company as well, and what other roles in the future will the server possible take on.
 
X99
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k @ 4.5ghz Gigabyte GA-Z68XP-UD3 HIS HD6950 2GB 8GB Corsair Vengeance 
Hard DriveOptical DriveCoolingOS
1x Crucial M4 64gb 2x 1TB Samsung Spinpoint F3 LiteOn Multi-DVD Burner Cooler Master Hyper 212 Windows 7 64bit 
MonitorMonitorMonitorKeyboard
Hannspree HF225   ACER H213H ASUS VH236H MS Sidewinder X4 
PowerCaseMouseMouse Pad
Corsair TX750 Cooler Master HAF 912 Logitech G500 Gigabyte Ghost 
CPUMotherboardGraphicsRAM
Intel Core i7 5820K Gigabyte X99 Gaming G1 EVGA GTX980 SC Corsair DDR4 
Hard DriveCoolingMonitorKeyboard
Samsung 1TB SSD Corsair H100i Dell U2715 Corsair K70 
CaseMouseAudio
Corsair 760T Logitech G502 Sennheiser Game One 
  hide details  
Reply
 
X99
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k @ 4.5ghz Gigabyte GA-Z68XP-UD3 HIS HD6950 2GB 8GB Corsair Vengeance 
Hard DriveOptical DriveCoolingOS
1x Crucial M4 64gb 2x 1TB Samsung Spinpoint F3 LiteOn Multi-DVD Burner Cooler Master Hyper 212 Windows 7 64bit 
MonitorMonitorMonitorKeyboard
Hannspree HF225   ACER H213H ASUS VH236H MS Sidewinder X4 
PowerCaseMouseMouse Pad
Corsair TX750 Cooler Master HAF 912 Logitech G500 Gigabyte Ghost 
CPUMotherboardGraphicsRAM
Intel Core i7 5820K Gigabyte X99 Gaming G1 EVGA GTX980 SC Corsair DDR4 
Hard DriveCoolingMonitorKeyboard
Samsung 1TB SSD Corsair H100i Dell U2715 Corsair K70 
CaseMouseAudio
Corsair 760T Logitech G502 Sennheiser Game One 
  hide details  
Reply
post #19 of 20
Quote:
Originally Posted by Iris View Post

We run Quick Books at work with 5 users M-F. We have 1 Super Micro Quad Core Xeon box with WD Green's in RAID 1 on a gigabit network. Quick Books is just a bit sluggish and not as quick as it should be. My guess those WD Greens are the bottleneck. I haven't checked the network utilization, but i'm guessing that's not the problem, it's the hard drives that's slow. Also could be that Quick Books is bloated garbage....

Quickbooks is a complete pig. It gets worse every year.
    
CPUMotherboardGraphicsRAM
2x intel Xeon E5-2650 Supermicro MBD-X9DR3-F-O Onboard awesomeness 8 x 8GB Kingston DDR3 1333 ECC 
Hard DriveCoolingOSMonitor
4x WD Green 2TB in RAID 10 2x Coolermaster Hyper 212 EVOs Windows Server 2012 Datacenter 3x Dell Ultrasharp U2410s 
PowerCase
Corsair AX1200 Case Labs TX10-D 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
2x intel Xeon E5-2650 Supermicro MBD-X9DR3-F-O Onboard awesomeness 8 x 8GB Kingston DDR3 1333 ECC 
Hard DriveCoolingOSMonitor
4x WD Green 2TB in RAID 10 2x Coolermaster Hyper 212 EVOs Windows Server 2012 Datacenter 3x Dell Ultrasharp U2410s 
PowerCase
Corsair AX1200 Case Labs TX10-D 
  hide details  
Reply
post #20 of 20
Thread Starter 
Took a look at their existing setup. It consists of a Pentium D with 2GB RAM and 160GB SATA HD. It is just a regular old dell dimension desktop.

I was looking at the I7 3770 but noticed I can get the E3-1245V2 Xeon for the same price. So I am thinking I might go that route but I wanted your guys thoughts on a couple things

The mobo, I was thinking this asus - http://www.newegg.com/Product/Product.aspx?Item=N82E16813131725

this ram- http://www.newegg.com/Product/Product.aspx?Item=N82E16820239117

and then for the RAID1 setup, do you think the onboard would be ok for this case or do you think I really need a dedicated card
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
Server/Gaming Rig
(22 items)
 
  
CPUCPUMotherboardGraphics
Intel E5-2670 intel E5-2670 Asus Z9PE-D8 WS Visiontek R9 390 
RAMHard DriveHard DriveHard Drive
8x4GB DDR3 1333 ECC Registered Toshiba 5TB X300 Seagate 4TB HGST 4TB 
Hard DriveHard DriveHard DriveHard Drive
Sandisk 240GB Sandisk 480GB Samsung 830 128GB Toshiba 6TB X300 
Hard DriveHard DriveOptical DriveOS
Toshiba 5TB X300 Toshiba 5TB X300 WH16NS40 Windows 10 Pro 
MonitorMonitorKeyboardPower
Dell S1715H Dell u2311h blackwidow ultimate Kingwin Lazer platinum 1000w 
CaseMouse
Corsair 800D Deathadder Chroma 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Servers
Overclock.net › Forums › Specialty Builds › Servers › Hardware for a quickbooks server