My bad ( I must have overlooked it because it shows as regular text in stead of a link )

fyi: Negative Blocking Session Ids

pick the one your consumer complaints most about.

After all, "slow" is a consumer experience.

does the query return a row with the given test data ?

How will your app react if there is no row returned?

thank you for the feedback.

ah, another issue with Windows 2022 !!

( we have an issue with HyperV clustered on Win2022 ( bluescreens ) )

Are the needed certificates installed on your SQL2019 ?

Easiest with DBATools Copy-DbaCredential

I hope your backups are in place !

If so, try to make an extra log-backup.

Secondly check your disk subsystem !

Only if that is ok, you are to restore the affected...

Check these articles:

Windows Server Failover Clustering with SQL Server

What is a SQL Server failover clustering

And with regards to Backups: Nothing changes compared to stand-alone instances

Maybe also ping the dbatools team with your findings !

That will only get you the currently cached plans.

You may want to activate QueryStore to have a better view over a given time frame.

Don't convert a columns data type if it is not needed

If conversion is needed, convert to the correct data type.

Declare @tb table ( FADate date not null,...

Double check the SSIS package, and see if it starts by clearing the table and/or does not overwrite existing data! #MyGuess

Maybe have a look at Gianluca's WorkloadTools to process the xe event files in bulk

"WorkloadTools : A collection of tools to collect, analyze and replay SQL Server workloads, on...

Keep in mind: Not just any kind of Azure BLOB storage! It needs to be V2 ! ( or newer )

And you have to remove these files yourself ! (...