Speed issues in Tax after upgrading to Practice Manager
This support note applies to:
- AE Practice Manager (AU)
- AE Tax (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: 34761
In Accountants Enterprise (AE) Practice Manager (AE PM) and AE Tax you may experience some slowness after upgrading to PM Plus integration.
Please find the file attached - Speedup.zip, this utility performs a number of functions including reindexing the AE PM database.
This utility is suitable to run on any version of AE PM and any version of SQL.
Ensure all users are logged out of all MYOB AE products and make sure you have a backup of both AE PM and Tax databases.
Before you begin, make sure to do a backup using one of the methods listed below:
- Backup via SQL Management Studio. See Backing up an SQL database using Management Studio
- Use the inbuilt backup tool in AE to run your backup. SeeBacking up and restoring data in AE Practice Manager
- Unzip Speedup.zip into a folder on C drive of the SQL server and rename the SpeedUpSqlDB to SpeedUpSqlDB.exe. The files are established.
- Double-click SpeedUpSqlDB.exe. The application runs.
- Select the name of your AE PM database, for example, VPMSER on server1 or AEDB1 on server1 and select the SQL Server authentication option. The login window appears.
Enter Login ID - SA and the password for this user.
Click Start to start the utility. The utility runs.
Run this utility twice, by running it again immediately after the first one completes.- Click Close. The speedup process is complete.