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.

Before running the utility

Make sure you’ve stopped all the MYOB Services

From the desktop of your server, click the Start menu and type services.msc. Then press Enter.
From the list of services, find and right-click the MYOB service you want to Stop.
- MYOB Backup service
- MYOB Tax SBR Sender Server
- MYOB Indexing Service
- MYOB Sync Client service
- MYOB OnTheGo API Service
- MYOB DM Portal Sync Service (If you have Document Manager)
Select Stop.

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.