We have SQL Server 2008 R2 32 bit installed on the following hardware:
- CPU: Intel Xeon E5310 @ 1.60 GHz
- RAM: 4 GB
- HDD: Raid
- Server: HP Proliant 120
- OS: Microsoft Windows Server 2003 R2, Standard Edition, Service Pack 2, 32 bit
The issue is that initially we run the application and when we try to open the first form from menu it takes time to open the form, and when we click on save it really takes time. When we restart entire server and we try we open the form again and save it, it really works very fast, but by the end of day it again gets slow and the entire server needs to be restarted.