Purging Old Data

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

Re: Purging Old Data

Veeam Logoby Shestakov » Tue Jun 23, 2015 3:49 pm

Well yes, if you want to have a lot of historical data for 7 hosts, 36 datastores and 157 VMs 10GB is not enough.
However, shrinking to 5 months can be enough for a while. Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Hovi » Wed Jun 24, 2015 12:16 pm

Hello,

I have the similar problem.

On version 8.0.0.1669 there is a "Full database" alert active, DB has about 9,5 GBs. I tried to set data retention period to 6 month, but I am stil able to see older data and stats and of course there was no effect on DB size.

Could you please advice - retention is set two days ago.



Thanks

Petr
Hovi
Novice
 
Posts: 7
Liked: never
Joined: Wed Jun 24, 2015 11:54 am
Full Name: Petr Hovorka

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Wed Jun 24, 2015 12:33 pm

How many objects (VMs/hosts/datastores) do you monitor with your installation?
Vitaliy S.
Veeam Software
 
Posts: 19974
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby Hovi » Wed Jun 24, 2015 12:45 pm

Infrastructure is vSphere 5.5
8 hosts
about 160 VMs
14 datastores
DB overgrows after about 8 months (installed 10/2014)
Hovi
Novice
 
Posts: 7
Liked: never
Joined: Wed Jun 24, 2015 11:54 am
Full Name: Petr Hovorka

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Jun 24, 2015 1:18 pm

Have you increased a number of monitored objects(datastores, VMs, Hosts) since 8 months ago?
Also, note that the task to clean database by retention executes once a day in Veeam One Monitor, once a week in Veeam One Reporter.
Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Hovi » Wed Jun 24, 2015 1:31 pm

As I checked, there are 3 new datastores and about 20 new VMs in last months.

New setting has been applied two days ago, Reporter is not used by the customer.

I made another DB backup and try to decrease retention to 2 months to be sure.

Thanks.
Hovi
Novice
 
Posts: 7
Liked: never
Joined: Wed Jun 24, 2015 11:54 am
Full Name: Petr Hovorka

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Jun 24, 2015 1:44 pm

Since the number of objects is constantly changing you can`t predict the exact number of months your DB can handle.
Another easy way to cope with small database is switching to the Advanced scalability mode. Rarer renewal intervals, but more historical data is to be stored.
Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Hovi » Thu Jun 25, 2015 11:28 pm

Hello again,

thanks for the tip - I did not know about the parameters coming with Advanced scalability mode.

It looks there is something wrong with my installation - with 2 months retention period set, I am still available to see data from the begining and DB says there is about 400 MB free space according SQL Management studio.

Do you have any idea how can I fix this state, please?
Hovi
Novice
 
Posts: 7
Liked: never
Joined: Wed Jun 24, 2015 11:54 am
Full Name: Petr Hovorka

Re: Purging Old Data

Veeam Logoby Shestakov » Fri Jun 26, 2015 9:34 am

Hello Petr,
I would suggest contacting our support team for the logs investigation.
Once you do, please post your support case number for the case monitoring purposes. Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Hovi » Sun Jun 28, 2015 9:30 pm

Hello,

problem seems to be solved. The problem was in SQL Express installation - after last update there was two instances - 2008 and 2012. After cleanup the old version everything goes OK - with 4 months data retention period there is DB about 8 GBs.

Thnaks for your hints!
Hovi
Novice
 
Posts: 7
Liked: never
Joined: Wed Jun 24, 2015 11:54 am
Full Name: Petr Hovorka

Re: Purging Old Data

Veeam Logoby Shestakov » Mon Jun 29, 2015 10:03 am

Thanks for updating Petr!
Have you figured it out with Veeam support? If yes, please provide the case number, so I can get details.
Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

[MERGED] Veeam ONE 7 and database size

Veeam Logoby EBoucq » Wed Aug 12, 2015 10:40 am

Hi,

My SQL database reached the max of 10 GB (SQL Express) so I ran VeealOneSettings.exe to decrease the retention period to 6 months.
What's the next step to really see the size of the .mdf decrease ?

Thank you.

Regards,
Eric
EBoucq
Expert
 
Posts: 215
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Aug 12, 2015 10:51 am

Hi Eric,
Note that task to clean database by retention executes once a day in Veeam One Monitor, once a week in Veeam One Reporter. When did you change the retention?
Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby EBoucq » Wed Aug 12, 2015 12:34 pm

Hi Nikita,

Thanks for your reply.
I changed the setting this morning. That explains why I didn't see any improvement yet :-)
So I guess I have nothing else to do but wait.
Eric.
EBoucq
Expert
 
Posts: 215
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: Purging Old Data

Veeam Logoby Shestakov » Wed Aug 12, 2015 12:40 pm

Correct.
Let me know if you have any results in a week.
I would also suggest to review the topic for the relevant information. Thanks!
Shestakov
Veeam Software
 
Posts: 5145
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

PreviousNext

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 1 guest