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.