Hello guys,
My users have been complaining a lot about an overall slowness on the system. After investigation, I have found that this slowness mainly occurs when they run reports, and not necessarily heavy ones, or when they use the excel add-in. I think that the problem occurs mainly on features that rely on WCF.
So far, everything in my system is configured according to best practice, and we have configured AOS load balancing. CPU & memory loads rarely exceed 60% on the AOS servers. Our users have the local client installed on their machines but their machines are quite old, the standard configuration being a core i3 2100, with 4GB RAM, but still higher than minimum requirements for AX.
On the dedicated SQL server, memory load is quite high, but from what I've read this is normal as SQL tries to be in a "comfort zone" memory-wise. Network-wise we have a dedicated 300mbps/<1ms latency connection to our clients and intra-server connection is GbE. We never use more than 50% of the client > server bandwidth.
My question is, will network load balancing improve the user experience when using reports ? Follow-up question would be, how tricky would it be to implement it on an already configured system ?
