Optimize Database Video

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 system should process routines faster after the optimize database routine is completed. 


Note: Please contact Dynamic Budgets support for assistance with this routine. An administrative password is required.




    • 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 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 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.

    • 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 ...

    • 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.