Open session report takes a long time

Availability for the Always-On Enterprise

Open session report takes a long time

Veeam Logoby dbr » Fri Apr 21, 2017 11:40 am

Hi,

we recently upgraded from 9.0 U2 to 9.5 U1. Open a report takes a relative long time even if session history retention is configured to 1 week (lowest possible value). I forced history cleanup by excuting stored procedure described in https://www.veeam.com/kb1995. Creating the report still takes about 10 seconds for a job that ran once a day (4 week retention = ca. 50 seconds / 12 week retention = ca. 90 seconds and more). Support told me it's normal that it takes that time (Case # 02130960) but it is not acceptable for me cause sometime I need a report that displays a longer time span than only one week. SQL server should have enough ressources to serve such a request (also tried with 4 vCPU and 24GB of RAM, no change). I guess the main bottleneck is the table Backup.Model.BackupTaskSessions. Do I have to live with it or is there any chance to speed up report creation?

Additionaly I noticed following:
- Browsing in Backups -> Disks is sometimes unresponsive. In 9.0 U1 I had no issues browsing our backups.
- Searching for a VM within an add dialog in Application Group takes a long time. In 9.0 U1 I had to wait severals seconds selecting a backed up vm in general. Anyway, both situation are no good.

Daniel
dbr
Enthusiast
 
Posts: 27
Liked: never
Joined: Thu Apr 06, 2017 9:48 am
Full Name: Daniel Brase

Re: Open session report takes a long time

Veeam Logoby v.Eremin » Sat Apr 22, 2017 12:04 pm

What edition does a SQL server have? It might be worth escalating a ticket or asking support team to run the very same query (as GUI session report does) to check whether underperforming SQL server is the root cause here. Thanks.
v.Eremin
Veeam Software
 
Posts: 13119
Liked: 953 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Open session report takes a long time

Veeam Logoby dbr » Sat Apr 22, 2017 9:58 pm

Hi Vladimir,

SQL server is a separate Microsoft SQL Server 2016 RTM Standard Edition on Windows Server 2012 R2. 2 vCPUs with 8GB of ram. While I ran the report the server wasn't really busy. Tried those reports in virtual lab with more cpu and ram but no change.

Daniel
dbr
Enthusiast
 
Posts: 27
Liked: never
Joined: Thu Apr 06, 2017 9:48 am
Full Name: Daniel Brase

Re: Open session report takes a long time

Veeam Logoby Gostev » Sun Apr 23, 2017 10:05 am

Could be that the query is not optimal. Please ask your support engineer to escalate the issue to R&D, we have the dedicated SQL guru for these sort of issues - it would be good for him to review and comment if this is "normal". Thanks!
Gostev
Veeam Software
 
Posts: 21365
Liked: 2337 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], foggy, Google [Bot], jmm, Poestges, theJonson and 50 guests