Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Large DPA repository database size when monitoring VMs

Large DPA repository database size when monitoring VMs

Updated August 29, 2016

Overview

Your DPA repository database may grow to a large size when you monitor database instances hosted on virtual machines (VM) with a large number of disk devices.

Environment

  • All versions of DPA

Cause

DPA collects Disk Drive metrics for VMs on a small sampling frequency, which may make the repository database grow quickly for large environments.

Resolution

For VMs with many disk devices, you can disable the Disk Device metrics to save space in the DPA repository database.

  1. On the DPA home page, click a monitored database instance that is hosted on a VM.
  2. Click the Resources tab in the upper right.
  3. Click the Disk Device sub-tab.
  4. Click Settings under the graph for the metric you want to disable.
  5. Select the Custom Resource Settings, and clear the Enable Data Collection check box.
  6. Save your changes.
    • Click OK to save for this VM.
    • Click Save as Default to make this the default configuration for all VMs.
  7. Repeat steps 4 - 6 for other metrics you want to disable.

 

*You may need to shrink your database datafiles in order to reclaim this space after a successful run of the cleaner process with the settings changed.  The default run of CLEAN_DAYS_OF_DETAIL process is 10PM.

 

 

 

Last modified

Tags

Classifications

Public