Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


New Server Hardware Configuration suggestions needed

New Server Hardware Configuration suggestions needed

New Server Hardware Configuration suggestions needed

Hi All,

Let me give you an idea of the configurations:

OS on Server: Win server 2003
SQL DB: Sql 2005 Enterprise Edition

Database: 15 Lakh records (will add 5 Lakh every 3 Months)
Size : 35 GB
Client Machines: 40 Desktop access this database.
Client OS: Win XP Pro.
Client Hardware: P4 233Ghz with 512MB RAM.
Application: CRM based application.
Other softwares running on Client machine: Microsoft Outlook, Word, Excel, Mozilla.
Connectivity: CRM application access SQL database thru ODBC driver created on the client machine.
Network: 100 Mbps LAN; Two D-Link switch to support this. Normal LAN wire.

Server will be a dedicated machine only to run the SQL Server application.

Application is a huge CRM based wherein it queries the complete 15 Lakh records evry time a new record is added to verify duplicates and while searching.

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.

Thanks a ton for all your valuable comments.



~*The Art of Communication*~

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close