Post reply

Newbie Question: How long does cube take to process

  • February 13, 2014 at 5:25 am

    #148144

    Hi - I am trying to find out how long a cube takes to process. I can see in a cubes properties when it was last processed but ideally I am after a list of the execute times for each cube. How can I do this?

    Thanks

  • February 13, 2014 at 6:50 am

    #1688710

    There isn't a way of seeing how long a cube took to process within the cube itself. However if the processing is done via an agent job you can look at the job history or if it's done by SSIS and it's logged then you can see it in there.

    I'm on LinkedIn

  • February 13, 2014 at 7:22 am

    #1688727

    Hi there thanks for the reply. The cube is processed by a SQL job so I can look at that. Out of interest I found this article on SSAS DMVs

    http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/

    Would I not be able to create a query to see how long a cube took to process from these?

  • February 13, 2014 at 7:51 am

    #1688747

    They only have information on when a partition/dimension was last processed and don't record any sort of history. Your best bet is using msdb.dbo.sysjobhistory and running a query on that.

    I'm on LinkedIn

  • February 13, 2014 at 7:56 am

    #1688752

    OK thanks

  • February 13, 2014 at 8:28 am

    #1688777

    If you process a cube through SSIS you can also observe the amount of time to process a cube by the log. If using SSIS 2012 you can check the reports in SSISDB for the package/task that launched the SSAS processing.

    If using an earlier version of SSIS you can set logging on the package task that processes the SSAS cube.

  • February 13, 2014 at 8:53 am

    #1688790

    There are also "Progress Begin", "Progress Current", and "Progress End" events thrown by the SSAS instance. These are the events captured by BIDS/SSDT-BI when reporting processing progress events when you processes an SSAS object thru BIDS.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply