alter memory in SSAS

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  July 25, 2014 at 8:43 pm

  #289062

  I am new to ssas , i need to change the memory in one of the SSAS instance , how can i change memory in SSAS ?

• MrG78

  Default port

  Points: 1482

  More actions

  July 28, 2014 at 2:09 am

  #1732722

  In SSMS if you connect to the SSAS instance and right-click on server and go to 'Properties' in here are a number of Memory metrics.

  The initial one to look at is:

  TotalMemoryLimit

  This will specify the maximum amount of physical memory the SSAS instance can use

  Below a value of 100 this is expressed as a percentage of the total server memory and above is expressed in bytes.

  http://msdn.microsoft.com/en-us/library/ms174514(v=sql.100).aspx