As a DBA, which would you pick for your workstation? QuadCore 2.4GHz with 12GB ram or Dual QuadCore 2.0GHz with 6GB ram?
1
-
5the more ram the better!– Daniel A. WhiteAug 10, 2009 at 13:16
Add a comment
|
3 Answers
Get the memory. 'As a DBA' you're going to be doing I/O bound work more than CPU bound work. Assuming you have a 64-bit O/S the memory is probably more useful than the CPU cores.
If you are feeling flush, get some internal disks (SSDs for the particularly well heeled) so you can test stuff locally on the machine. I use XW9300s (pimped somewhat by adding internal SCSI disk arrays) for data warehouse development work with Windows XP and SQL Server developer edition. This works surprisingly well. A 64-bit build with 12GB of RAM would be even better, and a similar trick could be done with Linux and Oracle.
answered Aug 10, 2009 at 13:20
-
-
Just as an aside, if you're considering a machine with fast local disks, look at something like an HP XW4600. These machines aren't much dearer than a normal PC but have a pci-e x4 slot that will take a RAID controller. Aug 10, 2009 at 18:52
I would go for the Dual Quad core and I will tell you why. Put simply the dual quadcore system will continue to be useful as it has enough processing capability that it will not be outpaced by the tendency of software to become more bloated over time.
You can always buy more memory when it is not running fast enough for you. And to be honest, the memory sticks are getting to be pretty cheap now.
Your system will have a much longer service life if you go with the one with the greater processing capability.
answered Aug 10, 2009 at 13:30
I would pick RAM over cores. Most programs aren't designed to the point of using more than 2-4 cores at the most.
answered Aug 10, 2009 at 13:20
-
1