Speed issues in MYOB AE or AO running SQL 2014 and above

This support note applies to:

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 37024

You may experience slow performance with MYOB Accountants Enterprise (MYOB AE) or MYOB Accountants Office (MYOB AO).

The attached batch file utility - speedup.txt, performs a number of functions including re-indexing the AE/AO database.

To run the utility

Download speedup.txtand save the file into a folder on C:\ drive of the SQL server.
Right-click on the speedup.txt file and from the drop-down menu, select Rename.
Change the name of the speedup.txt file to speedup.bat.
On the desktop of the SQL server, right-click on the Windows Start menu
and choose Run.
In the Open field, type C:\speedup.bat_SERVERNAME\INSTANCENAME_DATABASE NAME. Where:
- SERVERNAME is your SQL Server name
- INSTANCENAME is the name of the SQL server instance (for example, MSSQLServer, MYOBACCT)
- DATABASE NAME is the name of your database (for example, VPMSER, AEDB1 or AODB1)
- _ is a space.
Once the utility has been run twice, re-start all MYOB Services from within Control Panel > Administrative Tools > Services and (if applicable) re-start the Vizpost background processes or Admin centre post-processes.

This utility should be run twice. Run the utility again, immediately after the first one completes.