Comprehensive data protection for all workloads
Post Reply
srebucci
Enthusiast
Posts: 34
Liked: 3 times
Joined: Apr 05, 2011 1:37 pm
Full Name: vmware
Contact:

Backup size and SAN impact

Post by srebucci » Mar 15, 2012 4:26 pm

Hi everybody,
my boss ask me about the impact of B&R on our SAN: I know that with this software the impact is minimal but I need numbers. In the Enterprise Manager, I could see the backup speed for the last 24 hours or 7 days but I need to know the MB moved every night from our SAN to our backup repository.

How could achieve this value?

Gostev
SVP, Product Management
Posts: 25834
Liked: 3979 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backup size and SAN impact

Post by Gostev » Mar 15, 2012 4:35 pm

Hi Simone, the job email reports does this information (for each VM in the job separately), so you can just do the math from there. You can also get the same report by right-clicking the required job session under History, and selecting Report. Hope this helps. Thanks!

srebucci
Enthusiast
Posts: 34
Liked: 3 times
Joined: Apr 05, 2011 1:37 pm
Full Name: vmware
Contact:

Re: Backup size and SAN impact

Post by srebucci » Mar 15, 2012 4:43 pm

Hi Gostev!

It's incredible how fast you and the others of the support team answer to our questions!
But I have 48 jobs... could you please tell me the SQL Table where these data are stored? This way I could prepare a query a plot this data in a graph easily.

Thank you,

Gostev
SVP, Product Management
Posts: 25834
Liked: 3979 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backup size and SAN impact

Post by Gostev » Mar 15, 2012 7:05 pm

That I do not know, unfortunately. We generally do not support direct interaction with the configuration database, so we do not have the database structure documented in any public-facing documentation (and I never really needed to research this myself). In fact, this data could be spread across a few tables. However, those few forum members who created some reports by pulling the data directly from SQL all said it was very easy for them to figure out what each database table is for. So, you could try that as well. Thanks!

srebucci
Enthusiast
Posts: 34
Liked: 3 times
Joined: Apr 05, 2011 1:37 pm
Full Name: vmware
Contact:

Re: Backup size and SAN impact

Post by srebucci » Mar 19, 2012 8:11 am

hi gostev I've found the right view in the database. in case of success, could I post the result for the community?

Gostev
SVP, Product Management
Posts: 25834
Liked: 3979 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backup size and SAN impact

Post by Gostev » Mar 19, 2012 3:39 pm

Sure thing! In fact, it would be much appreciated.

srebucci
Enthusiast
Posts: 34
Liked: 3 times
Joined: Apr 05, 2011 1:37 pm
Full Name: vmware
Contact:

Re: Backup size and SAN impact

Post by srebucci » Mar 19, 2012 4:52 pm 1 person likes this post

Hi Gostev,
the view is the [VeeamBackup].[dbo].[ReportSessionsView].

This view is used by the Realtime Statistics menu (Right Click on a Backup Job) to get the main data of this dialog: the values are in bytes, so, if you need MB or TB, you simply need to do the math (as the Veeam B&R GUI do).
I've simply used the SQL Server Management Studio to query this view about all my jobs executions between 4 PM to 5 AM (my nightly backup window); then I've exported the data on CSV on do the plot for my boss on Excel.

SELECT TOP 1000 [id]
,[job_name]
,[state]
,[creation_time]
,[end_time]
,[job_type]
,[is_startfull]
,[operation]
,[processed_objects]
,[total_objects]
,[result]
,[total_size]
,[processed_size]
,[processed_used_size]
,[progress]
,[is_retry]
,[avg_speed]
,[read_size]
,[stored_size]
,[failed]
,[usn]
FROM [VeeamBackup].[dbo].[ReportSessionsView]
where [creation_time] > '2012-03-18 16:00:00.000' and [creation_time] < '2012-03-19 07:00:00.000'
order by [creation_time] desc;

The column name are easy to read: by the way, "very great job!!!" to the DB team.
I hope this help everyone on the forum to answer the question: how many MB/GB/TB Veeam read every night from the SAN? The short answer: only the changed ones. But sometimes (especially for the IT bosses) numbers matters.

vcosonok
Lurker
Posts: 2
Liked: never
Joined: Apr 13, 2012 10:51 pm
Full Name: Vidad Cosonok
Contact:

Re: Backup size and SAN impact

Post by vcosonok » Apr 13, 2012 11:06 pm

Hello Simone

Thank you very much for posting your SQL query. I was looking for some way to pull information out of the VeeamBackup database so I could make a Gantt Chart to display when job runs were overlapping, and came across your topic and SQL query which was the foundation for solving my conundrum. The result is posted at http://cosonok.blogspot.com/2012/04/vee ... ining.html

Cheers!

Post Reply

Who is online

Users browsing this forum: Bing [Bot], GeorgeV and 71 guests