I think you just have to start from the actual CU you are trying to install:

Set-Location 'E:\SQL_2019\patches'
SQLServer2019-KB4577194-x64.exe /ACTION=Patch /ALLINSTANCES /QUIETSIMPLE /IACCEPTPYTHONLICENSETERMS /IACCEPTROPENLICENSETERMS /IACCEPTSQLSERVERLICENSETERMS

Just my 2ct: Check this value.

Maybe activating this setting can take some pressure of your plan cache because it only has to calculate the stub and not actually put it...

Of course, a monitoring product is nice and fine and $$

But, if you are on a 0 budget, you could start the KISS way:

( we always install as DBA DBMail...

for what it's worth ...

- it took me 5 years to get our apps to a state that sysadmin was no more needed and no non-dba had sysadmin at OS...

have a look at SQLServer Joins

Start with Database Migration Assistant (DMA)

but I don't think it holds migration data for ssis.

• This reply was modified 6 days, 23 hours ago by  Johan Bijnens.

MADE MY DAY ! ! 😀

Thank you for sharing this estonishing "story from the trenches".

Happy new year.

I think you forgot to pose the question related to this execution plan.

Just reply the question and attach the .sqlplan renamed to .txt file.

Happy new year !

Why did you configure that many Listeners ?

A listener is a AD object, managed by your windows cluster.

A single one could be sufficient to have you AG available

listeners-client-connectivity-application-failover

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server

Check out Query Store

my QS ref: https://www.sqlskills.com/blogs/erin/category/query-store/

I hope you mean the TSQL way for compression!

 backup database xyz ... with compression ;

Do not use compression at windows operating system level !

Unless you have...

• This reply was modified 1 month, 4 weeks ago by  Johan Bijnens.

Double check your target folder itself ( or volume ) has not been enabled for compression !

SQLServer does weird things when someone enables compression at disk level.

are you producing striped backup files ?  (  Backup database - working with a striped media set )

That may also help to reduce the time needed. ( if that...