Purging Old Data

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

Re: Purging Old Data

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

At the same time, I tried to remove a Veeam server from the backup infrastructure view in the Data Protection View but it says 'deleting' and it's been showing that info for 3 hours.
could this be related to the fact the database is full ?

Thanks.
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 2:29 pm

Full database should not interrupt with VBR servers removal.
Try to refresh/restart Veeam One monitor.
Shestakov
Veeam Software
 
Posts: 5141
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 » Thu Aug 13, 2015 9:42 am

Hi,

After 24 hours, the database is still 10 GB and it still says deleting in the Data Protection View tab where I tried to remove a Veeam B&R server....
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 » Thu Aug 13, 2015 10:29 am

Hmm.. That is an unexpected behavior.
Please contact Veeam technical support for the detailed investigation.
Thanks!
Shestakov
Veeam Software
 
Posts: 5141
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

[MERGED]: Database Size - VeeamOne

Veeam Logoby BSalyer » Mon Jan 11, 2016 2:46 pm

I currently have VeeamOne installed (8.0.0.1669) under the Free license and monitoring 5 Hyper-V Hosts, 46 VM clients.
I installed it on 1/7/16 and my database is currently 15GB. I'm sure that's not terrible, but I'd like to limit the size of the database to prevent it from growing extensively as it did in my late attempt at Veeam. Previously I had 12 hosts on it and the database grew to over 800GB, we had to turn it off to prevent impacting other systems and I'm getting back around to working on it. I have another 7 hosts to add, and roughly another 70 clients, but I'm not sure what this will do to the database size.

I know prior to update 2 there was an issue with Veeam collecting too much data from Hyper-V. I'd like to avoid that situation this time around if I can.

I set the Historical Data Retention Period to 1 months per the VeeamOne support tool.

If it helps, the database lives on a server running Microsoft SQL 2012 (11.0.2218)


Is there anything else I can do, or look at, to make sure the database size stays reasonable? What kind of size could I expect for a 12 host, ~120 client database?
BSalyer
Novice
 
Posts: 6
Liked: never
Joined: Fri Mar 27, 2015 1:12 pm

Re: Purging Old Data

Veeam Logoby Shestakov » Mon Jan 11, 2016 3:28 pm

Hello,

Keep in mind that new Historical Data Retention Period needs time to be renewed. When did you set it?
15GB is not enough for 12 hosts with 120 VMs. How many months of monitoring would you like to have?
Thanks!
Shestakov
Veeam Software
 
Posts: 5141
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Mon Jan 11, 2016 3:32 pm

You can fine tune the amount of Hyper-V events stored in the database with the help of our support team.
Vitaliy S.
Veeam Software
 
Posts: 19966
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby BSalyer » Tue Jan 12, 2016 2:22 pm

Since I'm on the free version I thought I could only view 7 days of data - which would make anything beyond that superfluous.

I'm just not sure what to expect for database size. I wasn't expecting 15 gb over 2 days with 5 hosts 46 clients - of which several ended up not reporting in after the first day. it just seemed like a large size for the comparatively little data.

I'll update to v9 and contact the support team per Vitality's recommendation if I continue to have problems with hosts reporting in, or database size.
BSalyer
Novice
 
Posts: 6
Liked: never
Joined: Fri Mar 27, 2015 1:12 pm

Re: Purging Old Data

Veeam Logoby Shestakov » Tue Jan 12, 2016 2:40 pm

BSalyer wrote:I'm just not sure what to expect for database size. I wasn't expecting 15 gb over 2 days with 5 hosts 46 clients - of which several ended up not reporting in after the first day. it just seemed like a large size for the comparatively little data.

That`s true. It looks like too much for 5 hosts and 1 months period. So contacting support is a good idea. Please provide your support case number once you have it.
Thanks!
Shestakov
Veeam Software
 
Posts: 5141
Liked: 430 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Tue Jan 12, 2016 2:45 pm

BSalyer wrote:Since I'm on the free version I thought I could only view 7 days of data - which would make anything beyond that superfluous.

That's correct, but please keep in mind that we still store data according to the configured retention policy settings. This will allow you to report on any data once you decide to switch to full license. Many customers found it handy especially for capacity planning and deployment project reports.
Vitaliy S.
Veeam Software
 
Posts: 19966
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby LeoKurz » Fri Feb 05, 2016 8:52 am

Shestakov wrote: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!


Any chance to trigger these processes manually (reboot)?

__Leo
LeoKurz
Veeam ProPartner
 
Posts: 22
Liked: 6 times
Joined: Wed Mar 16, 2011 8:36 am
Full Name: Leonhard Kurz

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Fri Feb 05, 2016 8:55 am

Our support team might have a script to initiate this task on demand. Out of curiosity, what's your DB current size and how many objects do you monitor (VMs, hosts, datastores)?
Vitaliy S.
Veeam Software
 
Posts: 19966
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Purging Old Data

Veeam Logoby LeoKurz » Fri Feb 05, 2016 9:06 am

I'm working as a consultant in different environments and I see the problem with the DB exceeeding the express limit of 10G regulary. Most customers running 4-10 Hosts with 200-500 vms. Most customers don't have the need for a retention time of 12 months, so reducing the time is mostly the solution. Would be nice, if I could force the purge of the old data manually.

__Leo
LeoKurz
Veeam ProPartner
 
Posts: 22
Liked: 6 times
Joined: Wed Mar 16, 2011 8:36 am
Full Name: Leonhard Kurz

Re: Purging Old Data

Veeam Logoby Vitaliy S. » Sun Feb 07, 2016 7:14 pm

Might be a good option to ask during initial setup/configuration. Thanks for the feedback!
Vitaliy S.
Veeam Software
 
Posts: 19966
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE 7.0 database size

Veeam Logoby haslund » Fri May 20, 2016 5:36 pm

Vitaliy S. wrote:Hi Dmitriy,

You can change retention policy settings via our support tool.

Here is a way to open it via Monitor GUI (v8 only): http://helpcenter.veeam.com/one/80/vsph ... tings.html

Alternatively, you can navigate to this tool manually:
Code: Select all
C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe

Let me know if that helps!


Very useful!
Rasmus Haslund
Principal Technologist, Global Education Services @ Veeam Software
Veeam Certified Architect #1 | Veeam Certified Trainer #4 [v7,v8,v9] | Veeam Certified Trainer Mentor #1
Twitter: @haslund
Blog: www.perfectcloud.org
haslund
Veeam Software
 
Posts: 279
Liked: 54 times
Joined: Thu Feb 16, 2012 7:35 am
Location: Denmark
Full Name: Rasmus Haslund

PreviousNext

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 1 guest