Database Server Hardware components (order of importance), CPU speed VS CPU cache vs RAM vs DISK

Posted by nulltorpedo on Server Fault See other posts from Server Fault or by nulltorpedo
Published on 2012-04-11T21:17:41Z Indexed on 2012/04/11 23:33 UTC
Read the original article Hit count: 421

I am new to database world and would like to know what are crucial hardware specs when it comes to database performance. I have searched the internet and found this so far (In order of decreasing importance):

1) Hard Disk: Get an SSD basically (much more IOPS than spinners)
2) Memory:    Get as much as you can afford
3) CPU:       For the same $ spent, prefer larger cache size over speed.

Are these findings sensible?

EDIT: I would like to focus on CPU speed VS CPU cache size.

EDIT2: The database is used to store some combination of ints and int arrays with few text fields. There are a lot of Select queries looking for existing entries. If entry is not found, then insert it. I would say most of processing would be trying to find a match across a table with 200 columns and 20k rows. The insert statements are very few.

EDIT3: Also, we have a lot of views (basically select queries).

© Server Fault or respective owner

Related posts about database

Related posts about database-performance