1. PDQ Deploy & Inventory Help Center
  2. Community
  3. General
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Answered

Automatically Optimize Database?

Avatar
isinfrastructure

Our database has been growing quite quickly as we use these tools more and more. In the spirit of PDQ though, I'd prefer to not do it by hand but have it happen on a schedule (ideally with reporting.) Is there any way to do this? So far my digging into this issue has turned up empty.

0

Comments

2 comments
Date Votes
  • Avatar
    Dakota Clark

    You can automate optimizing the database by using the command line tools to do so.

    The syntax and options:

    C:\> PDQDeploy Help OptimizeDatabase
NAME
        OptimizeDatabase
SYNTAX
        OptimizeDatabase [-Wait]



C:\> PDQInventory Help OptimizeDatabase
NAME
        OptimizeDatabase
SYNTAX
        OptimizeDatabase [-Wait]
    0
  • Avatar
    isinfrastructure

    Perfect! Thanks for the help.

    0