PowerPivot SSAS instance on a Sharepoint server RRS feed

  • Question

  • Hi everybody,

    I work on a Sharepoint 2010 server which hosts a SSAS PowerPivot instance.
    I've just connected to this instance with Management Studio and I'm surprised by the number of databases I can see.
    It seems that one database is created at each report process.
    Is it normal?
    Is there a way to get rid of old databases?



    Tuesday, September 2, 2014 1:06 PM


  • Pete, 

    That is normal and I would not suggest doing any management of that instance. It is managed by SharePoint. 

    If the database is not used for two days, it is detached to the data cache. If there are five days of non-use, then it is deleted.

    I also recommend these 4 videos for SharePoint Architecture by Lee Graber: Here

    Hope this helps.


    Denver, CO

    • Proposed as answer by Charlie Liao Wednesday, September 3, 2014 9:44 AM
    • Marked as answer by Charlie Liao Wednesday, September 10, 2014 11:06 AM
    Tuesday, September 2, 2014 8:05 PM