- Posts: 1
- Liked: 1 time
- Joined: Jun 18, 2014 12:56 pm
- Full Name: Dave Rowson
I would like to raise the following issue, not a fault, but will more than likely impact many users.
veeam one monitor, version 126.96.36.1996
We are an extensive Veeam backup and replication user, together with the Veeam one monitoring product, and have been for many years.
Our Veeam one monitoring runs on the shipped sql 2008 express database, and constantly runs out of space, monitoring out 130 vm’s.
I am not interested in historical data longer than 1 month, however the only options for retention are 6 months, 1 year upwards, and as a result the database fills up quickly.
When raised with support under Case # 00523336 we are told that there is no way to reduce it, other than run a script to clear the database!
You can remove all data by using the following script.
PLEASE, back up the Veeam One database before you proceed past this line.
Truncate table monitor.PerfSampleMed
Truncate table monitor.PerfSampleLow
Update monitor.VwCollectorConfig set last_perf_rt_poll_time = null
Veeam One will then pull available data from the VC and you will have the VO database consistent with what is in the VC database.
I have created a sql batch file that clears the data out each month, but surely there is a better solution?
Is this something that your aware of, or planning to offer an alternative in the future?
- Product Manager
- Posts: 22127
- Liked: 1381 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
Yes, we are planning to give more flexibility in retention policy settings in the next major release. Meanwhile, you may want to change retention policy settings via this script:
Code: Select all
update common.ServerSettings set RetentionPolicyPeriod = %MONTHS%
Users browsing this forum: No registered users and 2 guests