Free Space in the DAS Database

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Steps to reduce (or slow the growth) of the database size.

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Resolution

Warning: Ensure there is a full backup of the DAS database before proceeding, and before each additional step:

1. Log in to the application server as the Carbon Black Service Account and launch SQL Server Management Studio.
2. Changing the Database Recovery Model from Full to Simple can reduce size. To shrink log after changing recovery model, execute the query:

   use DAS;
   DBCC SHRINKFILE (N'das_log' , 0, TRUNCATEONLY);

3. Confirm that the DailyPruneTask is completing successfully (Support.php > Scheduled Tasks tab)
4. Evaluate adjusting the Old Computer Cleanup options.
5. Evaluate lowering the Event Retention settings
6. Evaluate discarding Microsoft-signed Files at the Agent.
7. Evaluate configuring Zero Prevalence Pruning.
8. Manually running the DailyPruneTask stored procedure could help reduce the database size if it has failed to execute recently.
9. If not using the CPE or CVE feature, be sure the data is fully removed and the feature disabled.

Note: The database may need to be shrunk again if changes were made, or after Zero Prevalence Pruning has had several days to work through changes.

Additional Information

• Missing SQL Permissions on the Service Account could contribute to Maintenance/Scheduled Task failures.
• Upgrading to the latest version of App Control Server will ensure the latest code improvements to database performance/maintenance have been applied.