I would like to raise the following issue, not a fault, but will more than likely impact many users.
veeam one monitor, version 22.214.171.1246
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?