We are using the Following Specifications for the ERP Application.
1. ASP 3.0 as Front End
2. Microsoft 2005 SQL server with sp3 as Back End
3. IIS 6.0 as Web Browser
4. Operating System 2003
5. Crystal Report 9.2
Initially we had used windows 2000 OS and MS-2000 SQL Server and the application was going well for past 1.5 year. Total No of Users where consistent users where 150 and we faced some time delay problem in the core2deo system. Later on after purchasing the IBM server we switched over to 2003 OS and MS-2005 SQL server. Right now the speed in initial state is good like within 1 sec the saving and retrieval is done. But after some time the performance goes down it is taking to 10 sec.
Right now the hardware setup is One database server (AMD server) one application server (IBM) and one domain server which is connecting this two servers. We had removed the antivirus in the network. And in the database tempdb database increase has been restricted. In all the server we had installed antivirus.