Reducing the size or growth of the DAS Database
search cancel

Reducing the size or growth of the DAS Database

book

Article ID: 286784

calendar_today

Updated On:

Products

Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

  • Steps to reduce (or slow the growth) of the database size
  • Trying to increase Free Space in the DAS Database

Environment

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

Resolution

Step 1: Prerequisite

  • Verify the App Control Database Server meets the minimum disk space requirements.
    • Server Documentation > relevant Version > Operating Environment Requirements > Server Architecture by Endpoint Count

Step 2: Evaluate Cleanup Options

  1. 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);
  2. Evaluate adjusting the Old Computer Cleanup options.
  3. Evaluate lowering the Event Retention settings
  4. Evaluate discarding Microsoft-signed Files at the Agent.
  5. Evaluate configuring Zero Prevalence Pruning.
  6. Manually running the DailyPruneTask stored procedure could help reduce the database size if it has failed to execute recently.
  7. If not using the CPE or CVE feature, be sure the data is fully removed and the feature disabled.

Note: Microsoft SQL databases do not automatically re-release previously used disk space . To reclaim previously used space, a Database Shrink would need to be done.

Step 3 : Still need help?

  1. Collect a Disk Usage Report
    1. Log in to the application server as the Carbon Black Service Account and launch SQL Server Management Studio.
    2. Right Click "Das" > Reports > Standard Reports > Disk Usage
  2. Collect Database Performance Logs
  3. Open a Technical Support Case and provide the Disk Usage Report and Database Performance Logs.

Additional Information

Powered by Wolken Software