There is a stored procedure that shows if there are queries waiting for memory or cpu

sp_PressureDetector | Erik Darling Data

I don't have the Azure version, but you could capture blocking events for review with Extended-Events on Azure SQL.

It is briefly mentioned in https://docs.microsoft.com/en-us/azure/azure-sql/database/understand-resolve-blocking

Thanks Jeffrey for mentioning it.

SSRS keeps the executions of reports in the view

SELECT *

FROM [ReportServer].[dbo].[ExecutionLog3]

You could use extended events to track if the database is still in use https://www.sqlskills.com/blogs/jonathan/tracking-sql-server-database-usage/

You can review https://sqlchicken.com/2012/07/identify-and-alert-for-long-running-agent-jobs/

and https://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

It looks they were databases for the SSRS instance DMP2.

Do they contain dbo.Catalog, dbo.ChunckData?

You could track logins against those databases with extented events Tracking Logins with Extended Events | Voice...

1) will my SSRS 2014 reports run as is once the upgrade to SSRS 2019 has been completed or will I need to rewrite my reports?

I suppose the most reports...

I wouldn't activate lock pages in memory SQL Server Max Memory Setting with Lock Pages in Memory (mssqltips.com)

The pagefile is rather for unexpected events, otherwise it has too few memory....

Thanks for the updated funtion

Also curious for other opinions

Since you only have one pair of drives I would keep it on a single partition with you can extend when needed.

For the pagefile I would...

The FTP-transfer is still binary ? (corruption with non-binary transfer)

What is the oldest open transaction ? DBCC OPENTRAN

Apparently Script: open transactions with text and plans - Paul S. Randal (sqlskills.com) has a script to show open transactions

SCOM 2019 SSRS would refuse to install  because the version was too high (it needed the RTM SQL Server (sigh)). I'll try it again on my laptop  (uninstall sql, install...

Maybe farfetched but is your sql server still RTM? I had problems with SCOM 2019 installation when the sql server was already patched and the "versions" didn't match (had to...

Are the sql server files excluded from antivirus?

Does it relate to backup times (more stress on io) / higher cpu usage ( certain batch with lot of iops)?

https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-833-database-engine-error?view=sql-server-ver15