Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

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