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