Unanswered: New Server Hardware Configuration suggestions needed
Let mw give you an idea of the current configurations:
Intel Quad Core 2.6 Ghz (Normal Desktop processor)
3 GB RAM DDR2
2 Hard drives - 160 GB Each
OS: Win server 2003
SQL: Sql 2005
Databse: 5 Lac records (will add 5 Lac every 3 Mths)
Size : 25 GB
Client MAchine: 40 Desktop access this database.
Client OS: win XP pro.
Connectivity: Front end application access thru ODBC drivers
Network: 100 Mbps LAN; Two D-Link switch to support this. Normal LAN wire.
Now my company does not want to spend huge amount on new hardware, but is interested in cost effective solution which can support for another 2 Years.
Any suggestions wherein we could change the hardware or software configuration.
Is this an upgrade? If so, how come you only have 5 thousand records now but will add 5 thousand every 3 months? Also, how come your database is 25GB with only 5 thousand records? Are the rows very wide?
My only question is how are the 5 lac records input? is it a batch at the end of the quarter, or will they be input manually a few thousand per day? if they will be inserted a few thousand per day, you will likely want a second physical drive array to house the transaction log, and keep that disk activity away from the people reading the database.
The Database has 5 Lakh records. Some records are manually saved in to the system and few are done using the software utility which adds a lot daily.
Each record has data as well as resume text also saved with it. My application is a HR based software. All emails that are received and resumes downloaded from Online databses are then either maually or using automation is added into the SQL DB.
According to wikipedia, Lac = Lakh. It's a north/south thing.
From the description given, I would have to say the power of the server is fine. You are not going to see the CPU work very hard, provided the application is designed properly. I do have an issue witht he disks, though. It seems you are not going with any kind of redundancy on the disks. I would very much recommend that you at least mirror the two physical drives. Remember, these drives are going to be spinning at 15,000 RPM every minute of every day for probably 3 years or so. Any failure of the disk could destroy part or more likely all of your database.