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

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

• Manage Company Databases Article

      Tutorial Link Purpose: To link to and setup company database(s) you wish to work with. An administrator selects which company databases to load into Dynamic Budgets by querying the GP Accounting (ERP) database.

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

• Manage Company Databases Tutorial

  PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: To link to and setup company database(s) you wish to work with. An administrator selects which company databases to load into Dynamic Budgets by querying ...