How to Fix Slow Query Performance (System Slowness) Article

How to Fix Slow Query Performance (System Slowness) Article

If both Great Plains Accounting Software and Dynamic Budgets are running slowing there might be an issue with the SQL server.  Please contact your IT departments to discuss.


However if you are noticing that only Dynamic Budgets is seems to be running slowly (for example, it takes 5 times more than usual to open a screen or run a report), we have a tool which might help.


1) From the dropdown menus select Tools/ Database Assistance / Optimize Database:


2) You will be promoted to enter the  password which is "OpenSesame#99" and then click "Go":



3) To optimize click the" Optimize Database" button ONCE:




4) After running this procedure, the database has to relearn how to run each type of report or query in the system.


To test the optimization run a Monthly Summary Accounts report or the Budgeting Dashboard, or Custom Reports and first search on one orgunit only to teach the system about this type of report.  Then run the same report for the entire company and you should see a vast speed improvement.


If you do not see substantially faster results please contact Dynamic Budgets support on 650-332-6651.



    • Related Articles

    • Optimize Database Article

              Tools:  Database Assistance / Optimize Database Purpose: If Dynamic Budgets, not GP, is suddenly running uncharacteristically slow, please click on the optimize database button within the Dynamic Budgets software. This button will run a ...
    • Optimize Database Video

      Purpose: If Dynamic Budgets, not GP, is suddenly running uncharacteristically slow, please click on the optimize database button within the Dynamic Budgets software. This button will run a Microsoft Updatsta.sql script to re-index the database. The ...
    • Optimize Database Tutorial

      PDF Tutorials Interacitve Tutorial  Cropped Screenshots Full Page Screenshots           Purpose: If Dynamic Budgets, not GP, is suddenly running uncharacteristically slow, please click on the optimize database button within the Dynamic Budgets ...
    • View Logins / System Shutdown Article

          Tutorial Link Video Link Purpose:  During System Maintenance, System Managers are the only users allowed in the system. The System Admin can disconnect all users, with a 3-min warning, that are currently connected to the application.
    • View System Logins, Shutdown System Video

      Purpose:  During System Maintenance, System Managers are the only users allowed in the system. The System Admin can disconnect all users, with a 3-min warning, that are currently connected to the application.