Severe performance issues on new server with MS SQL Server R2 Standard /Sage 200
Posted on 2011-10-04
We have a network that we have just rolled out and we have installed Sage 200 which users MS SQL R2 Standard edition.
All seemed to go well although the users have reported Sage is VERY slow and I can confirm. Therefore if they flick between pages in the application, any page that required data can take about 50 seconds to load.
More or less unusable.
We have for moments having it running normal speed which is lovely then for no reason it goes back and in the last 18 hours we have not had a time when it run OK.
We have done lots of things like remote AV from the server and workstation, but we still get the issue when running SAGE directly on the server with a keyboard and mouse plugged in..
We have a guy from Sage with us now who is reasonably technical but not a deep knowledge of Sage so we are unsure where to do.
What could cause such performance issues. Note that the server is well spec'd with 24GB, SAS drives dual processer - brand new and no more then 10 users (only 4 of Sage).
How can we diagnose this problem. Is there logs we can run to see what is happening on each page change and why it takes so long.
Although not directly our responsibility as another company installed Sage as we look after the network we want to be certain we have everything solid.
Thanks in advance to anyone who can help