I am running an application that query the database a lot, around 500 queuries (insert/update/select) each second. I want to buy a dedicated server to run that application, there are mainly 3 tables (out of 20) that gets most of the queries (like 99% of them).
I am not really a hardware guy, so I was wondering if I can share with you the server I am interested in, and you'll tell me if it should be enough, if you can of course, by your estimates.
Must of the information goes into/out of the db database is int/decimals.
One of the tables should contain around 50,000 records, another table should contain around 500,000 records, and the biggest table should contain more then a million.
I know these numbers are not THAT big, but I don't really know what to expect to, I am running my application on a smaller server now and it gets high CPU cause of all the transactions. so my new server is:
- Server: Dell PowerEdge R710
- CPU: 2x Intel Quad Core E5504
- Harddisk: 2x500GB SATA2
- RAM: 16GB DDR3
- Software: Microsoft SQL Server 2008 Web Edition (2 Processor)
- OS: Windows Server 2008 R2 Web (2 CPU)
Do you think it will be enough?