Monitoring and reporting for Veeam Data Platform
Post Reply
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Veeam One Reporting slow

Post by dreyer »

Hi,

creating and showing reports take a few minutes with my veeamOne installation, depending on the specific report.
A simple report ( performance of one vm, last day for example) takes 1-2 minutes bigger reports (host performance 6 month e.g.) take 5-15 minutes.
The veeamOne Server is a vm with 16 cpu's and 24 gb ram.
In veeamOne 18 vm hosts are monitored. the database-server is a sql server enterprise with uses all cpu's.
Server OS is windows server 2008 r2.

Do you think the duration of creating report is okay i need some comparision.

Thanks!
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Hi Dreyer,

Do you have SQL Server installed on the same servers as Veeam ONE? Do you use SSRS?

Thanks!
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

>Do you have SQL Server installed on the same servers as Veeam ONE?

Yes

>Do you use SSRS?

No
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Since you have SQL Server Enterprise Edition, I would suggest running database partitioning script, this should improve the performance of reports generation. We have this KB article which refers to SQL Server 2012R2, but if you contact our technical team directly, they will provide you with instructions that should be done in SQL Server 2008R2.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

I will make a support ticket for configuring partitioning for sql server 2008. Another question: do you think srss will raise the speed of report creation too ?
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Yes, it should. Also separating SQL Server and Veeam ONE server should also increase the overall performance, but first let's start with database partitioning. Let me know how report generation improves after that.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer » 1 person likes this post

edt: case 00823764
I will. Thanks so far.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

Hi,

i tried out database partitioning -> no better performance

best regards
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Ok, let me involve our dev team into this.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

Hi again,

i heared nothing from your dev-team.
Have you already contacted them ?

best regards
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Hi Dreyer, I see that you have closed your ticket and was planning to do some other changes. Our support team is waiting for the feedback on this change before escalating it to devs.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

As i wrote on 6th of march -> no better performance since database partitioning.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Can you inform your engineer about this (can't escalate the closed ticket), as this should re-open the ticket?
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

Dont understand your question. Please reopen the ticket i still need help with raising performance for report-building. The DB-Partitioning did nor solve the problem, i need help trying other changes on our Veeamone server.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

I see that your ticket (00823764) has been closed, that's why I've asked you to re-open it, so we could continue troubleshooting this via debug logs review. Sorry for the confusion.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

Hi,

... still waiting for some reaction .....
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Did you re-open the ticket as I have asked in the previous post (don't see it in the support system)? Also let me inform your technical engineer about this directly.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer » 1 person likes this post

Hi Vitaliy,

cannot reopen ticket.
Here is a new one: (00867738)
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Thanks, I have also escalated this case internally.
dreyer
Influencer
Posts: 11
Liked: 2 times
Joined: Mar 05, 2015 8:46 am
Full Name: Dreyer
Contact:

Re: Veeam One Reporting slow

Post by dreyer »

Here an update for other customers with this 'problem':

The Support wrote me that its normal that report-creating takes so long and recommended me setting up an standalone SRSS server. They have tested report-building with our database in their labs it took 10 minutes for rendering too (report: Capacity Planning, full scope)

Regarding to the support we need at least two, better three servers (veeam one , + sql server, sql srss standalone server) to run the software with an acceptable speed.

its a little pity that we need two sql server enterprise lizences to make veeam one usable for us and its even more pity that it took almost two month to get this information!

I will try now setting up an srss server and hope this will solve our 'problem'.

BG
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam One Reporting slow

Post by Vitaliy S. »

Hi Dreyer,

Thanks for updating your topic with a resolution. It is indeed recommended to use SSRS and database partitioning to make reports run with acceptable performance and I have stated this in my first post ;)

Three servers might not be required, you can combine SSRS and SQL Server roles and deploy it in a single machine. Let me know what performance you will have after installing SSRS server. In addition to this, I would appreciate if you could post the results (before and after), so that I could show it to our dev team for review.

Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 16 guests