Automatically Optimize Database?

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.

Comments

2 comments

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]

Information Systems
July 30, 2019 16:25

Perfect! Thanks for the help.

0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post