Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Reduce DPA repository size

Reduce DPA repository size

Table of contents
Created by Robert Holtam, last modified by Aileen de Lara_ret on Aug 17, 2016

Views: 912 Votes: 1 Revisions: 4

Updated  August 17, 2016

Overview

This article provides steps to reduce the size of your DPA repository. 

 

About  90% of storage usage occurs within the first 30 days of collection per instance. Reducing the clean_days_of_detail setting is the biggest lever to pull to reduce your repository size.

 

Note: Changing this setting will affect the number of days displayed on the DPA Home page when clicking on an instance. By making this change, the second by second data will be summarized. This setting can no longer be reverted to display additional days. 

Environment

All DPA versions

Steps

When this setting is changed, a job runs nightly to summarize the data that is collected every second. The data then is summarized into a hourly view. This change is not immediate, and within 24 hours, the data will summarize and will purge on its own.

1. Select the arrow on the monitored instance you want to change this option for. 

2. Click Advanced Options. 

3. Click DB Instance Option, and then select your target instance. 

4. Click CLEAN_DAYS_OF_DETAIL. This is a monitored instance specific option. Change it for all monitored instances that you want it to be non-default. The default value is 30 days.

 

Here are the approximate size requirements per monitored instance you should expect within your repository.

Light 1 GB to 3 GB
Medium 3 GB to 5 GB
Heavy 5 GB to 10 GB

 

 

 

Last modified

Tags

Classifications

Public