locked
How to monitor proactive caching? RRS feed

  • Question

  • Is there an XMLA or MDX query that will return the last "update" time for a cube that's using pro-active caching? Our goal is to create a web page that polls this information so that our non-technical users can see how fresh the data in the cube should be.

    Also, on a related note, if we have pro-active caching enabled and it starts a refresh at minute 1 and then data is entered into the source db at minute 2, will that new data be included in the refreshed cube or will it have to wait for the next cache update?

    Thanks,

    .jelling
    Tuesday, January 5, 2010 5:32 PM

Answers

  • Is there an XMLA or MDX query that will return the last "update" time for a cube


    There is a similar thread you can refer to:

    http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/37bfff0f-e09b-40da-addb-524ba0c178c4

    I would suggest using DMV:

    SELECT [CATALOG_NAME], CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBES

     

    if we have pro-active caching enabled and it starts a refresh at minute 1 and then data is entered into the source db at minute 2, will that new data be included in the refreshed cube or will it have to wait for the next cache update?


    If the current processing has not been finished, then it will stop the current one and wait for the next one. So, Silence override interval is important,
    without this setting you could conceivably have changes that keep occurring and the partition would never get processed. More information, you can refer to:

    http://www.mssqltips.com/tip.asp?tip=1563

     

    Hope this helps.

    Raymond

    • Marked as answer by Raymond-Lee Friday, January 15, 2010 3:51 AM
    Thursday, January 7, 2010 10:09 AM