The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Search the VMware Knowledge Base (KB)
View by Article ID
Performing maintenance on the vCenter VMware Protect database (2041491)
Purpose
This article provides information about performing maintenance on your vCenter Protect database.
The primary reasons for proper database maintenance include:
Increased performance
Version upgrade preparation
Creating additional hard drive space
Resolution
Scan results comprise the bulk of the size of the vCenter VMware Protect database, so reducing the amount of scans stored in the database has a direct effect on the size of the database. You can choose to remove old scan results from the database using one of these options:
Navigate to Manage > Items in vCenter VMware Protect:
From this screen, you can see items like patch scans, asset scans, deployments, and threat scans. Each category is separated, so you can delete items from only one category at a time.
To delete individual items, click the item and click Delete Selected (in the upper right of the screen).
To delete all items of a certain type, click Delete All (to the upper right of the designated type).
Note: This same action can be initiated for Patch Deployment, Threat Scan, and Asset Scan items.
Automated method using the Database Maintenance function in vCenter VMware Protect 8.x:
You can configure this feature by navigating to Tools > Database Maintenance in the vCenter Protect Console. You can use Max Results to Keep and Delete Result(s) older than options alone or together to define which results are deleted. To initiate the deletion, using Run Now without setting up a schedule. Alternatively, you can set the database maintenance to run on a reoccurring scheduled date and time. This feature can also be used to rebuild the indexes for the Protect databases and create backups.
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.
