
Previously, it wasn't anything that I noticed as being particularly slow, so I can't put a time to how long I would have waited for the results to come back. But I just timed how long it took for the System section to return results, and it took 1 minute and 45 seconds. Once results are returned, filtering is near-instant. And I can flick between different sections that have returned results and instantly see the results: so if I have waited for Jobs and System to both return results, I can select either of them and have instant results shown. It is only the first time I click on the individual sections that things are incredibly slow.
The Veeam server is a not-too-ancient Dell R740, with 8 core CPU & 64GB RAM, running Windows Server 2019.
Veeam is running the latest April 2023 patch.
The Veeam database is running in SQL Express 2017 on the same box.
The do.Backup.Model.BackupTaskSessions table has 179,376 records, while the dbo.Backup.Model.BackupTaskSessionProgress table has 2,734,962 entries.
SQL Activity monitor shows a very nested select query sitting there for the whole time I am waiting ("with bk_sess_by_policy as ( select ....").
Is there any tuning I can do, or is this a known change/issue?
Thanks.