Blog Post

SQL Server Support Blog
5 MIN READ

OS Hang or Out of Memory due to SQL Ser... No Wait, it's SQL Analysis Services (SSAS)

Joseph_Pilov's avatar
Joseph_Pilov
Icon for Microsoft rankMicrosoft
Feb 11, 2019
First published on MSDN on Jan 12, 2018 Recently, we have observed a number of cases where DBAs or application developers are complaining about out-of-memory errors or even machine not respondin...
Updated Apr 12, 2021
Version 6.0
Analysis Services(SSAS)
memory
Performance
troubleshooting
dvenardos's avatar
dvenardos
Copper Contributor
Feb 22, 2024

This is a Windows defect.

If memory allocation calls are going to fail due to a lack of resident available memory then Windows should be setting the memory pressure state so that applications can voluntarily release memory rather than just crashing.