Automatically Optimize Database?

Answered

Follow

Information Systems

• July 30, 2019 14:04

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

• 

  Dakota Clark

  • July 30, 2019 15:32

  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

  Comment actions Permalink
• 

  Information Systems

  • July 30, 2019 16:25

  Perfect! Thanks for the help.

  0

  Comment actions Permalink

Please sign in to leave a comment.