Speed issues in MYOB AE or AO running SQL 2014 and above
This support note applies to:
AO Practice Manager (NZ)
AO Practice Manager (AU)
AE Practice Manager (NZ)
AE Practice Manager (AU)
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.
Changethe 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 > AdministrativeTools > 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.
JavaScript errors detected
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.