July 27, 2009 at 2:04 pm
Hi,
Thank you for detailed explanation how x86 system allocate memory, but this leads me to the two questions:
1. why during processing SSAS return error when reach about 3GB, instead of move memory to page file.
2. assuming that I will move to 64bit, how many memory SSAS will try allocate during processing, I don' know how estimate memory requirements (as I mentioned my SSAS database take only about 4GB)
July 28, 2009 at 6:02 am
SSAS in 32-bit mode looks at the physical memory available on the box as reported by Windows, and limits its use within that. Therefore it will give you an error message if you want to use more memory than is available.
This can be a particular problem if you have a large amount of data in dimensions, because SSAS insists on loading all dimension data into memory. If you have more dimension data than you have memory then SSAS will give you an error.
On 64-bit SSAS I am not certain if SSAS will look at physical memory or the total of physical and page file memory. SQL DB services looks at the latter.
Regardless of this, if you have 16 GB memory on the box then SSAS should be able to use up to about 12 or 13 GB, assuming you have absolutely nothing apart from Windows and SSAS running on the box. If you have SQL DB services running also, then SSAS can only use what is left after DB services has taken what it wants.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 28, 2009 at 12:57 pm
This can be a particular problem if you have a large amount of data in dimensions, because SSAS insists on loading all dimension data into memory. If you have more dimension data than you have memory then SSAS will give you an error.
Thank you again, Is it possible measure/estimate my current dimension size? I don't see any option from GUI (SSMS).
Does SSAS sum all dimensions and problem occur when sum of all dimension exceed about 3GB? or when one of the dimension take about 3GB?
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply