Performance issues on a standalone or network

• Actian is running as a pre-load or is damaged and needs to be reinstalled
• Permission settings over the network are preventing Sage 50 from running with full control
• Slow network speed
• Data size is over the recommended size for optimal system performance

CAUTION: 

Uninstall and reinstall Actian Zen

• See How to completely remove and reinstall Pervasive/Actian

Switch ini file to look at shared network drive instead of UNC path

• See How do I update the INI file on the workstations?

Sharing permissions and security

1. If the shared data folder's permissions and/or security haven’t been set properly, it can cause slowness. See Verify my data file permissions are correctly set.
2. Make sure that the network drive at each workstation maps directly to the shared folder and not a sub-folder. For example, Sage 50 is shared, but the drive is mapped to "Company". If it is, disconnect and remap the drive.

Sage company size

• The size of a Sage company directly affects program performance; large databases can result in longer load times for the program.
• To check a company's size, select Help, Support Utilities, and then File Statistics.
• Large companies should be purged to remove old transactions/inactive records and decrease the company size. See When should I purge my data?.

User Account Control (UAC)

• In Windows 8.1 or 10, UAC can cause slowness by not allowing Sage to properly access the shared data files and/or program files.
• See How to disable User Account Control (UAC).

IPv6

• If using Windows 8.1, or 10, disabling IPv6 will significantly improve Sage's performance but can causes issues with Windows OS.
• Instead, configure Windows OS to prefer IPv4 addresses over IPv6. See How to set Windows 10 to prefer IPv4 over IPv6
• Consult with your Local IT or Network Administrator for assistance with this.

Antivirus and firewall software

• See Files to allow through firewall and antivirus
• Contact your IT professional or your security software's manufacturer for instructions on configuring the exceptions list.

Network connection

• Use on a wireless network can result in performance and/or data integrity issues. It’s recommended to use a hard-wired connection with the program.
• Verify the server and workstations are on the same domain or workgroup.
• Verify the server can ping the workstation by name and receive a response from the correct IP address and that the workstation can ping the server by name. See How do I ping the server from a workstation or vice versa?
• Check the network speed; see How to check network speed
• Network-related issues can be confirmed by changing one of the workstations to a local data path and opening a sample company. If the performance issues desist after bringing the data to the local machine, contact an IT professional to troubleshoot across the network. See How to change a workstation into a standalone temporarily after a server failure
• Verify that there are no bad or faulty network cables or network cards in the environment. Replace any damaged equipment.
• If the computer experiencing the performance issue has dual network interfaces (active wireless and wired network connections), disable the unused interface.
• Consult with your IT professional to diagnose and repair network latency.

Memory and processor speed

1. Make sure each computer meets at least the minimum processor and RAM requirements for Sage. See Sage 50—U.S. Edition System Requirements documentation.
2. At the server, increase your amount of RAM in correspondence with the number of workstations accessing Sage. A good benchmark is 2GB of RAM per workstation.
3. More memory/processor speed will also be required if working in multiple companies at once.
4. Check Sage's performance at the server; if the server is slow, every workstation will also be slow.
5. Verify the processor and memory resources haven’t been artificially limited by pressing the Windows+R keys, type msconfig, and then click OK.
   Note: If prompted to allow the program to make changes, select Yes.
6. Select Boot tab.
7. Select Advanced options.
8. If either Number of processors or Maximum memory is selected, clear them.
9. Select OK.
10. Select OK again.
11. Restart the computer.

Hard Drive space and virtual memory

• Each PC's hard drive should have a minimum of 1 GB or three times the company database size, whichever is larger, of free space.
• Running Windows' Disk Cleanup and Defragmenter utilities at each PC will optimize free disk space.
• Each computer's virtual memory should be set so that it at least matches the amount of RAM on the machine.
• As with RAM, the more virtual memory a computer has, the better it will run.
• Follow the link in Additional information below for Microsoft instructions on checking and changing the amount of virtual memory.

Background applications

1. Other programs and background applications running at the same time as Sage may cause slow performance.
2. Try rebooting your computers into Selective Startup to verify if background programs are affecting Sage's performance. See How to boot into selective startup.
3. If performance improves after doing so, start re-enabling services and startup items one at a time until the one causing the issue is found.

Data entry

The following changes can improve performance but aren’t always necessary. It’s best to make a few changes and then work in Sage to test the results.

• Change Global Options

1. Select Options, and then Global.
2. Select General tab.
3. Check one or more options under Improve Performance.
4. Clear Smart Data Entry.
5. Select OK.

 NOTE: When entering transactions, use unique reference (invoice, check, etc.) numbers. 

• Change Action Items settings

1. Select Tasks, Action Items.
2. Select Options, and then Transactions tab.
3. Clear each Create Event option.
4. Select Start Up tab.
5. Clear Display Action Items each time a new company is opened.
6. Select OK, and then Close.

Compatibility settings

1. Right-click Sage Icon, and then select Properties.
2. Select Compatibility tab.
3. If Run this program in compatibility mode for is selected, clear it.
   Note: If the check box is grayed out, just continue to the next step.
4. Select Change settings for all users.
5. If Run this program in compatibility mode for is selected, clear it.
6. Select Run this program as an administrator.
7. Select Apply.
8. Select OK.

Microsoft .NET issues

• See How do I check for Microsoft Framework .NET Errors using the Sage Advisor Diagnostic Tool?
• Contact an IT professional or Microsoft support for assistance installing/reinstalling Microsoft .NET 4.0.
• If using Windows 8, Microsoft .NET 4.5 is built into the operating system, so instead of reinstalling it, disable it, reboot, and then re-enable it.

The user doesn’t have the correct access

Each user in the network needs either Administrator or Power User access.

Oversized FRM files

1. Check the Forms and individual company directories, sorting the files in the directory by size.
2. Any large forms can be moved out of the Forms and individual company directories. If these are custom form files, you can re-customize them.
3. Verify the program is more responsive.

Uninstall and reinstall Sage

1. See How do I uninstall the program?
2. Reinstall Sage; see Installation Instructions - Sage 50—U.S. Edition

Windows Update

1. Check for any pending or needed windows updates, Contact an IT professional or Microsoft support for assistance.
2. You can view your Windows updates in Windows 10, by typing updates where it says Type here to search on your bottom taskbar.
3. On the menu that appears you can then click Check for updates.