el236
Technical User
- Nov 2, 2002
- 50
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.
EL!
EL236
~*The Art of Communication*~
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.
EL!
EL236
~*The Art of Communication*~