Database doubled in size (short-term retention policy) (4327250)

WORKAROUND:

Retention Policy to Short term  increases the granularity of data stored (every 5 minutes) and keeps this data for two weeks.
Which leads to growth of the database.

Please find the breakdown of data samples used by each Retention Policy:

Long Term Policy:

Store raw data in memory for 15 minutes. 
Roll-up raw data to 15 minute averages and store for 3 days.  = 4/hour*24(hours)*3(days) =288 data samples.
Roll-up data to hourly averages and store for 2 weeks.  = 24 (hours)*14 (days) = 336  data samples.
Roll-up hourly data to 4-hour averages and store indefinitely. = 6/day*30 days  = about 180 data samples./month.
Total Long term is 288+336+ ( 180 data samples. each month ) 

Short term will store data averaged at 5 minute intervals for 2 weeks.
Total Short term= 12/hour*24 hours*14 days = 4032 data samples (will keep 2 weeks) 

Managed Roll-ups are similar than Long term but they purge the 4 hour averages after 4 months (288+336+180*4 months=1344  data samples).

As you can see the Short Term policy stores much more data as the Long term.

To resolve the DB growth issue, please change to appropriate retention policy that suits you except short-term retention policy.

If you want to keep the current policy (ie. Short-term ), you might want to increase storage or maybe slecet Managed Roll-ups.

You can also create a custom one with data purge after few months (ie. 12 months = 2784 data samples )