June 4, 2018 at 10:58 am
Hello everyone
I have a sql server installation request for an SSAS engine
4On this type of specific installation that is dedicated to make cube
show can I fix the memory min and max memory
for info the server is with 20 G memory
thank you
June 4, 2018 at 1:29 pm
joujousagem2006 1602 - Monday, June 4, 2018 10:58 AMHello everyone
I have a sql server installation request for an SSAS engine
4On this type of specific installation that is dedicated to make cube
show can I fix the memory min and max memory
for info the server is with 20 G memory
thank you
SSAS uses LowMemoryLimit, TotalMemoryLimit, HardMemoryLimit
June 4, 2018 at 1:32 pm
Sue_H - Monday, June 4, 2018 1:29 PMjoujousagem2006 1602 - Monday, June 4, 2018 10:58 AMHello everyone
I have a sql server installation request for an SSAS engine
4On this type of specific installation that is dedicated to make cube
show can I fix the memory min and max memory
for info the server is with 20 G memory
thank youSSAS uses LowMemoryLimit, TotalMemoryLimit, HardMemoryLimit
Sorry...hit post too soon. And the explanation and defaults are listed in this documentation:
Memory Properties
If you want to change these, the settings are in the msmdsrv.ini file in your SSAS directory to OLAP\Config folder
You can also connect to SSAS using SSMS. Then right click on the Analysis Services node and select properties. Go to the general page and you can find memory and other configuration options.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply