After many years dealing with Sage Line50 it is no surprise that I am a little upset that Sage will STILL NOT utilize Microsoft’s SQL server for the database backend. There was a sign that Sage were moving over to SQL when a beta of Sage Line50 had been issued to a number of ”testers” only for me to find out the other day that Sage have put it on hold for the foreseeable future due to ”problems”.
Being an IT Administrator for our company, Specialist Building Factors, has led to many complaints from our users why Sage Line 50 runs so slow over a network. There has been many upgrades and tweaks to squeeze every bit out of our network. Our network at the moment comprises the following:
1 x Dell PowerEdge T310 Quad Core 2.5GTZ server running SBS 2008 with 12GB ram (4 SAS disks Raid10 – the sage data is also held on this server as a temp measure)
1 x Dell PowerEdge 1600SC running Server 2008 4GB ram (This is down at a remote branch running as a backup domain controller, dhcp, and print server)
1 x Dell 16 port Gigabit switch coupled with 2 x cisco routers for our remote branch connection via VPN
19 x Windows XP + Windows 7 desktops (all running Sage Line 50) (4 of these at the remote branch running over terminal services)
The antivirus protecting our network was Avast! AntiVirus 4.8 Professional running on the Main server using the Avast ADNM console to manage the whole installation. The root of all the Slow Sage Line 50 problems was…… Avast , simply disabling the Avast shields on the clients and the server was not good enough, the Avast product had to be FULLY uninstalled.
OK, so the Sage Line 50 speed over the network is back again, the problem was now to find a good AV product, server/client friendly that did not impact Sage. This led me to ESET’s NOD32 AntiVirus program, I installed this across our network and on all servers and the Antivirus impact on Sage Line 50 is minimal. It is widely regarded by many IT Admins as the best AV software, and from my point of view if you use Sage Line 50 on a network, scrap your current AV software and use ESET’s, you won’t be disappointed.
Hope this helps, if it does please leave comments or, ask any questions for others to reference.