Veeam One Reporting slow

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

Veeam One Reporting slow

Veeam Logoby dreyer » Thu Mar 05, 2015 8:54 am

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!
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Thu Mar 05, 2015 10:36 am

Hi Dreyer,

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

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Thu Mar 05, 2015 1:06 pm

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

Yes

>Do you use SSRS?

No
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Thu Mar 05, 2015 1:53 pm

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.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Thu Mar 05, 2015 2:34 pm

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 ?
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Thu Mar 05, 2015 2:44 pm

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.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Thu Mar 05, 2015 3:08 pm 1 person likes this post

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

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Fri Mar 06, 2015 2:07 pm

Hi,

i tried out database partitioning -> no better performance

best regards
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Fri Mar 06, 2015 3:00 pm

Ok, let me involve our dev team into this.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Thu Mar 19, 2015 8:54 am

Hi again,

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

best regards
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Thu Mar 19, 2015 9:26 am

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.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Fri Mar 20, 2015 11:20 am

As i wrote on 6th of march -> no better performance since database partitioning.
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Fri Mar 20, 2015 11:26 am

Can you inform your engineer about this (can't escalate the closed ticket), as this should re-open the ticket?
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One Reporting slow

Veeam Logoby dreyer » Fri Mar 20, 2015 3:39 pm

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.
dreyer
Influencer
 
Posts: 11
Liked: 2 times
Joined: Thu Mar 05, 2015 8:46 am
Full Name: Dreyer

Re: Veeam One Reporting slow

Veeam Logoby Vitaliy S. » Fri Mar 20, 2015 3:48 pm

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.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Next

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 4 guests