Veeam ONE Database size becomming large

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

Veeam ONE Database size becomming large

Veeam Logoby bgalante » Wed Jan 13, 2016 7:41 pm

Hi,

Is there a way to trim the size of the database? Our DB is growing and we have to keep adding space to accommodate it.
Any help is appreciated, thank you!
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Wed Jan 13, 2016 7:51 pm

How large is your database right now and how many hosts/VMs/datastores you have in the infrastructure?
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Wed Jan 13, 2016 8:03 pm

The DB is 60GB as of now.

There are 41 Hosts, 936 VM's, and about 72 datastores.
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Wed Jan 13, 2016 9:45 pm

Is it all Hyper-v or VMware infrastructure? What is the Veeam ONE version and build number you're running?
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Thu Jan 14, 2016 2:02 pm

It's all VMWare, and version is - Version: 8.0.0.1669
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Thu Jan 14, 2016 4:22 pm

How long have you been running Veeam ONE? The most growth of the database happens during first 2 weeks.
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Fri Jan 15, 2016 4:17 pm

It's been running for about 6 months, it did grow a lot at the beginning but recently we seem to have had another surge.
I can't say exactly how much, but the DBA said it was significant.

Really just looking for a way to reduce / prune / compress it. I'm hoping that's possible. Or at least to limit it to where it is now.
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Fri Jan 15, 2016 4:32 pm

You can limit the size of the database by adjusting the retention policy settings. Here is a related topic for more info > Purging Old Data.

In addition to this, you can switch to advanced scalability mode that will instruct our engine to store less data in the database. Finally, can you please execute the script below and tell us the output?

This script will show what type of data (performance, events etc.) is taking most space in your database:

Code: Select all
create table #tbl ([schema_name] nvarchar(max), table_name nvarchar(max), index_name  nvarchar(max),
used_in_kb  bigint, reserved_in_kb bigint, rows bigint)
go
 
with table_space_usage
([schema_name], table_name, index_name, used, reserved, ind_rows, tbl_rows)
as (
select s.Name, o.Name, coalesce(i.Name, 'heap'), p.used_page_count*8,
p.reserved_page_count*8, p.[row_count], case when i.index_id in (0,1) then p.[row_count] else 0 end
from sys.dm_db_partition_stats p
join sys.objects as o on o.object_id = p.object_id
join sys.schemas as s on s.schema_id = o.schema_id
left join sys.indexes as i on o.object_id = p.object_id and i.index_id = p.index_id
where o.type_desc = 'USER_TABLE'
and o.is_ms_shipped = 0
)
insert #tbl
select t.[schema_name], t.table_name, t.index_name, SUM(t.used) as used_in_kb,
SUM(t.reserved) as reserved_in_kb, case GROUPING(t.index_name) when 0 then SUM(t.ind_rows)
else SUM(t.tbl_rows) end as rows
from table_space_usage as t
group by t.[schema_name], t.table_name, t.index_name
with rollup
order by GROUPING(t.[schema_name]), t.[schema_name],
 GROUPING(t.table_name), t.table_name,
 GROUPING(t.index_name), t.index_name
go
select * from #tbl as t
order by t.used_in_kb desc


drop table #tbl
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Fri Jan 15, 2016 7:35 pm

Here is the first few lines from the file:

Code: Select all
NULL   NULL   NULL   9509261528   9514791456   112461430992
monitor   NULL   NULL   9211994328   9215276992   110702948311
monitor   PerfSampleMed   NULL   5349331008   5351438592   66187338392
monitor   PerfSampleLow   NULL   3613348800   3614029696   43129507142
monitor   PerfSampleMed   clst   666639776   666742224   11752891864
monitor   PerfSampleLow   clst   434420256   434483792   7658510614
monitor   PerfSampleMed   cl   350863040   350916960   6185732560
monitor   PerfSampleMed   nc1   346105840   346437960   7113592444
reporter   NULL   NULL   296257216   297097312   1754186143
monitor   PerfSampleLow   nc1   253190256   253260360   4635414319
reporter   ObjectProperty   NULL   235402296   235888376   1557604778


The link you pointed me to, which said run "veeamONEsettings.exe, when I try to run that, I get an error of "invalid license data - reinstall required.
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Sun Jan 17, 2016 9:00 pm

Are you using free or paid version of Veeam ONE? Do you try to run it via Veeam Monitor Client or directly from the folder?
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Mon Jan 18, 2016 1:52 pm

I'm using the paid version, and I'm trying to open it from right inside the folder.
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Mon Jan 18, 2016 2:12 pm

While I'm trying to find out the reason for this error message, can you please try to open this tool via Veeam ONE Monitor Client? Navigate to server settings menu to locate it.
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Mon Jan 18, 2016 6:48 pm

I went in the Veeam ONE monitor. I went to settings, on the "other settings" tab, there is a "Support Utility" which says "Use this utility for advanced Veeam ONE configuration" However when I launch it, it comes back and says "Login failed for user (Me)" Is this where you wanted me to navigate?
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Re: Veeam ONE Database size becomming large

Veeam Logoby Vitaliy S. » Mon Jan 18, 2016 8:48 pm

Yes, that's the place. Are you able to open via any other Veeam ONE admin account? If not, then please let our support team take a look at the issue, so that we could adjust the retention policy for your database.
Vitaliy S.
Veeam Software
 
Posts: 19942
Liked: 1144 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE Database size becomming large

Veeam Logoby bgalante » Tue Jan 19, 2016 2:09 pm

I was able to get in via a different user.

I'm looking at the general section, and the "Retention Policy Period" tab Which is currently set at 12 months.

If I change this to 3 months, will that automatically purge the old data or is there an additional step? Specifically to reduce the size of the DB on disk.
bgalante
Enthusiast
 
Posts: 35
Liked: 1 time
Joined: Mon Jul 27, 2015 5:14 pm
Full Name: Brian Galante

Next

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 1 guest