database server Sizing
Posted on 2009-04-02
I am working on a Siebel database server upgrade project. I am trying to find out what kind of hardware I will need for this project.
1. The current server is a Dell 6650 4 CPU/1 core machine with 16 GB RAM and uses SAN as storage.
2. The server runs MS SQL 2000 and has 160 GB of data. The data size is expected to grow to at least 240 GB within next 4 years.
3. The system experienced multiple major performance issues a few weeks ago, but it is faster now after performing performance tuning. However, it still takes at least 5 seconds for an external user to login into the Siebel service request module.
4. The system supports 1100 internal users and 10,000 external users through Siebel service request module.
5. Some of the frequently used tables have more than 1 million records.
6. The entire application has around 150 concurrent users connecting to the database server. My team is going to add significant functionality within the next year and is expecting up to 600 concurrent users. Majority of the connections will come from customized code, not Siebel.
Based on discussions with DBA and information from various sources, I am recommending my team to upgrade the server to a 4 CPU/Quad core machine with 64 GB RAM. I am recommending the big size RAM because some of the new code modules need high speed query to reduce waiting time for external uses under high stress load.
My company's server team is recommending a 2 CPU/QUAD core machine with 32 GB of RAM. The team has provided me some benchmark information from Intel and severs vendors. While the numbers look good, I know from my real life experience, a quad core CPU at best is about twice as fast as a single core CPU when running real world applications. Is this machine good enough for the kind of load that I am planning for?