Program is running very slow
Posted by Sinclair Hughes, Last modified by Jane Hughes on 30 November 2020 09:58 AM

Check these:

  • Virus-checker.  Make sure the program directory is excluded from real-time virus scanning

  • SQL Server Transaction log file is very large.  This should never need to get over 1GB.  Check the SQL backup script includes a function to Truncate the Transaction Log.

  • Are you using Hyper-V virtual machines and does the server(s) have Broadcom network cards?  If yes, there is a known problem caused by the Virtual Machine Queues (VMQ) function that is known to cause significant network speed problems and turning it off instantly Improves the performance. 
    https://support.microsoft.com/en-us/kb/2902166