At our company, we support a SQL Cluster that holds the SSRS databases, among other user dbs.
I'm not an SSRS expert, so excuse me if I'm miss something, but the fact is that SQL Server Agent has thousands of SSRS jobs, above 24K. That is enormous, I know.
Our particular issue is that when someone opens the SQL Backup GUI and connects to the cluster, that session blocks the msdb database and makes SQL Agent to hang; I assume because it's trying to query all the jobs. We need then to kill that session to get the SQL Agent going again, otherwise the reports start failing, the jobs doesn't start and everything related with SQL Agent fails.
Is there a way to avoid SQL Backup to block msdb? Has anyone been into this situation before?
Any comments will be highly appreciated.