Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS2012 - Is There A Query To Show Cube Processing Time Expand / Collapse
Author
Message
Posted Monday, October 21, 2013 9:20 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 4, 2014 10:11 AM
Points: 892, Visits: 1,560
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!
Post #1506714
Posted Tuesday, October 22, 2013 5:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:54 AM
Points: 243, Visits: 2,753
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.
Post #1507060
Posted Wednesday, October 23, 2013 11:58 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:09 AM
Points: 1,046, Visits: 1,846
The SSIS way is the way to go!

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1507884
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse