We have an application which runs already with its database on server. Because of the large amount of I/O (read and write) from this applications database we have very slow responses to our queries. So, we've decided to build a new server machine to install there that application with its database. The database size is 15Gb with 10-100 transactions/sec ,there are at least 5 physical users and 10-20 other from other applications which connects to this database and the average IOPS is 150 to 200.
The machine we're thinking to buy is detailed below. Interesting points:
- Two raid 1 arrays. one for the database and another one for the system.
- Xeon 2.4Ghz
- 12GB RAM
- Two raid 1 arrays. 4 146GB 15K disks
- Windows server 2008 R2
- Microsoft SQL Server 2008 standard.
What do you think about it??