Hello,
I'm getting closer to the SQL Express limit for VeeamONE database and I tried to follow KB2357 without gaining too much free space.
I've run the SQL Studio report for "Disk usage by Top Tables" and it seems that reporter.ObjectProperty table is using 4.5GB of space!
Is that normal? there is a way to shrink the table?
Regards
Giuseppe
-
- Novice
- Posts: 8
- Liked: never
- Joined: Aug 18, 2017 2:54 pm
- Full Name: Giuseppe Ravasio
- Contact:
-
- Veteran
- Posts: 3077
- Liked: 455 times
- Joined: Aug 07, 2018 3:11 pm
- Full Name: Fedor Maslov
- Contact:
Re: SQL reporter.ObjectProperty size
Hi Guiseppe,
Yes, this situation may be fine (it depends on the source dataset size) so the recommendation is to move to the Standard or Enterprise editions - technically, you can upgrade the SQL edition quite easily through the built-in SQL edition upgrade procedure. Just do not forget to stop Veeam ONE services before upgrading.
The alternative is to delete more historical data, as described in the KB article, but obviously, it's not a permanent solution.
Thanks
Yes, this situation may be fine (it depends on the source dataset size) so the recommendation is to move to the Standard or Enterprise editions - technically, you can upgrade the SQL edition quite easily through the built-in SQL edition upgrade procedure. Just do not forget to stop Veeam ONE services before upgrading.
The alternative is to delete more historical data, as described in the KB article, but obviously, it's not a permanent solution.
Thanks
-
- Novice
- Posts: 8
- Liked: never
- Joined: Aug 18, 2017 2:54 pm
- Full Name: Giuseppe Ravasio
- Contact:
Re: SQL reporter.ObjectProperty size
Hi wishr.
thanks for the answer.
I asked because I have only 3 hosts and about 70Vms and I deleted a lot of historical data but that had effect only on perfsamplelow table, that is now down to about 600MB.
On the other hand the table ObjectProperty wasn't reduced at all, and i tought it wasn't normal.
Anyway If that's normak I will look into licensing a new SQLServer.
Thanks
Giuseppe
thanks for the answer.
I asked because I have only 3 hosts and about 70Vms and I deleted a lot of historical data but that had effect only on perfsamplelow table, that is now down to about 600MB.
On the other hand the table ObjectProperty wasn't reduced at all, and i tought it wasn't normal.
Anyway If that's normak I will look into licensing a new SQLServer.
Thanks
Giuseppe
-
- Veteran
- Posts: 3077
- Liked: 455 times
- Joined: Aug 07, 2018 3:11 pm
- Full Name: Fedor Maslov
- Contact:
Re: SQL reporter.ObjectProperty size
Hi Guiseppe,
Yes, even for that low number of VMs the size of the table looks expected.
The reporter.ObjectProperty table stores critical reporting data and can not be cleaned manually or even using simple scripts. To decrease the size of this table you may modify the data retention settings within the Veeam ONE Settings Utility. Please, take a look at the KB2051 for details.
I hope it helps!
Yes, even for that low number of VMs the size of the table looks expected.
The reporter.ObjectProperty table stores critical reporting data and can not be cleaned manually or even using simple scripts. To decrease the size of this table you may modify the data retention settings within the Veeam ONE Settings Utility. Please, take a look at the KB2051 for details.
I hope it helps!
-
- Novice
- Posts: 8
- Liked: never
- Joined: Aug 18, 2017 2:54 pm
- Full Name: Giuseppe Ravasio
- Contact:
Re: SQL reporter.ObjectProperty size
Hi wishr,
thanks for the explanation and for the time.
Giuseppe
thanks for the explanation and for the time.
Giuseppe
Who is online
Users browsing this forum: No registered users and 9 guests