Sometimes, re-designing your processes is the best approach.

If the  installation media 2019 does not do the job, clean up the registry.  You may consider repairing the windows.

Apologies, the web site duplicated my response twice.

Yes, as others stated, with no tracing data, we are guessing. However, you may consider checking the following:

-----------------------------------------------------------------------------------------------------------------------

"tempdb" contention could cause issues.  (one tempdb file for each logical core.)

https://www.sqlshack.com/sql-server-tempdb-database-and-latch-contention/

Please check...

Yes, as others stated, with no tracing data, we are guessing. However, you may consider checking the following:

-----------------------------------------------------------------------------------------------------------------------

"tempdb" contention could cause issues.  (one tempdb file for each logical core.)

https://www.sqlshack.com/sql-server-tempdb-database-and-latch-contention/

Please check...

Third party monitoring tools could cause performance issues for your database platform unless you know how to use them properly.

I would write your own tools if you can.

Please see Brent Ozar's recommendations:

https://www.brentozar.com/archive/category/production-database-administration/monitoring/

Please read on: netcoreapp3.0 - not sure if this could help.

you may use Availability Groups (also known as AlwaysOn Availability Groups) on SQL Server 2022 Standard Edition, but with limitations - you can only create "Basic" Availability Groups which restrict...

Please apply firewall rule for inbound/outbound port 1433 (on the server and your computer).

It is best to use more secure ports / certificate.  DO you have connect database connect permission...

Good work Jeff.

Also, ensure the MIN/MAX SQL memory is assigned properly.

Server has 32 GB, Min: 8 GB / Max 24 GB (for example)

With VM servers, sufficient memory is essential.

When the process hangs, is the CPU/memory pegged at 100 percent?

Please check for CPU pressure or memory pressure.

Pinal Dave has good articles on wait types.

Just to get a clear idea, is this a SQL task executed after hours?   If you run the process during the normal day hours, yes, you could see deadlocks challenging...

All these are helpful:

1. Ensure the table statistics are up-to-date.
2. Ensure you have sufficient memory / Disk space available.
3. Consider NUMA processor configuration changes.

   1. Some of the logical processors are...