Our Sage 50 application takes a long time to load. We recently moved it to a newer server and the speed has improved but opening the application and accessing data is still time consuming and not acceptable to the company owner. Takes about 3-5 minutes.
His computer is a Core i7, 256GB SSD, 8GB memory and GbE connection. File transfers to our file server is quick so I don't see anything that could be slowing things down on his computer. The application will open fairly quick if no company data is selected.
Our current Sage server runs a RAID 1 on WD Raptors, SATA2. Server has about 8-10 connections for the Sage application and another 6-7 users for another application that also runs a DB on it for engineering. Watching the network monitor, network usage seems low. Drive access is 50% or higher at all times. CPU is about 20-30%. Memory used is around 2.72GB jumping to 3-3.3GB.
What are some things I can do to diagnose the slow speed? Could it be the hard drives on the server? What RAID setup would be recommended, 1, 5, 10?
Budget is allowed to use SSD's as cache if required. We currently use Adaptec cards for our other servers. Not sure which card is used for this one as it was a prior purchase from Dell.
Client runs Windows 7 Pro x64
Server runs Windows Server 2008 R2
Best Answer
It's hard to diagnose this kind of issue over the web... there's just so many things that can be a factor. But I did spot two items in the question worth highlighting:
and
This indicates that you might be able to improve throughput by going to RAID 10 with higher-speed SAS disks, or by using SSDs (or both RAID 10 and SSDs).
But again, this is really just a guess until you can do some real profiling.