NOLOCK without NOLOCK, page latch time-out on tempdb and finally DUMP…


Infrastructure

Starting a new installation of SQL Server 2019 Enterprise (15.0.2000.5 / X64 on Windows Server 2019 Standard 10.0 / Build 17763) on a new physical machine (2 machines for AlwaysOn replicas).
The new machines are a LENOVO :
* ThinkSystem SR630 – [7X02CTO1WW]
* 1 CPU : 1 Xeon Gold 6208U – 2.90 Ghz (16 cores x 2 – hyperthreading)
* 256 Gb RAM (32 Gb x 8)
There are 2 new identical machines and the problem appears systematically on the 2 machines…

The tests that generate the malfunctions are as follows:
1) creation of a database
2) enlarging