SSAS2012 - Is There A Query To Show Cube Processing Time

• YSLGuru

  SSC-Insane

  Points: 21632

  More actions

  October 21, 2013 at 9:20 am

  #300298

  Is there a query in SSAS 2012 that will show the total time a cube took to process? If yes then is there a way to see this same info historically so that the duraction of 2 or more rebuilds can be compared? What about a history of processing exections that shows each time the cube has been proceessed?

  Thanks

  Kindest Regards,

  Just say No to Facebook!

• Scott Murray-240410

  SSCarpal Tunnel

  Points: 4649

  More actions

  October 22, 2013 at 5:15 am

  #1660447

  A couple of thoughts on this item. First I am not aware of a way to use the SSAS DMVs to find the full processing time.

  However, if you use a SQL Agent job, you could use the job times to determine the processing times.

  OR

  If the flight recorder is enabled, you could use that.

  OR

  IF you process the cubes via a SSIS Package your could add some logging.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 23, 2013 at 11:58 pm

  #1661144

  The SSIS way is the way to go!

  Raunak J