SXA site pages might fail to load with increased resource consumption. The issue occurs when several threads are concurrently trying to write to the SXA[InjectedRenderingsCacheName] cache. This results in some requests getting stuck.
To resolve the issue, consider one of the following options:
<setting name="XA.Foundation.Presentation.InjectedRenderingsCacheMaxSize" value="0MB" />