Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have SQL Server 2008 R2 32 bit installed on the following hardware:

  1. CPU: Intel Xeon E5310 @ 1.60 GHz
  2. RAM: 4 GB
  3. HDD: Raid
  4. Server: HP Proliant 120
  5. 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.

share|improve this question
    
Have a look at my blog post here to see if any of it applies (I have a feeling it does). Also, see this question and its answers. –  Jon Seigel Apr 24 '13 at 13:26
    
What is the Max Memory for the instance and are you running a stand alone instance or multiple instances on the same 2003 windows server ? –  Kin Apr 24 '13 at 13:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.