How SSAS use TempDB and how to redue size of log file?

• jarupan

  SSCommitted

  Points: 1746

  More actions

  January 23, 2012 at 9:41 am

  #148949

  Hi All,

  I try to check how SSAS use Tempdb and how to reduce size of SSAS log file?

  In my case we use MOLAP.

  Any ideas or links, I will be really appreciated.

  Thank you in advance.

  JJ

• Sam Vanga

  SSCommitted

  Points: 1742

  More actions

  January 25, 2012 at 8:27 pm

  #1438547

  If you are asking if SSAS uses tempDB, No. SSAS doesn't use TempDB for querying.

  TempDB might be used when source data is processed to SSAS.

  Sam Vanga
  http://SamuelVanga.com