June 19, 2014 at 8:58 am
Hello,
I am using SQL 2005 SSAS, and would like to know how can I tell which cube takes the longest to process and include start and end times processing times. I saw on blogs that there are DMV's for 2012, but I couldn't find anything for 2005.
Any help would be greatly appreciated!
SQL-TG
Everyone has a plan until they get punched in the mouth. --Mike Tyson
June 20, 2014 at 2:25 am
Although 2005 doesn't have DMVs it is still compatible with the Analysis Services Stored Procedure library on codeplex: https://asstoredprocedures.codeplex.com/.
You'll find plenty of info in there in the CubeInfo class, but not how long a processing time has been. Your best bet is to have some sort of log table on your SQL instance and log the start and finish times for each process and each cube. So, for example, if you had an SSIS package which processed your cubes you would have an execute SQL task before processing which did a simple insert and then one after which did an update (or another insert depending on how you want your table structured).
June 20, 2014 at 2:17 pm
Thanks!
Everyone has a plan until they get punched in the mouth. --Mike Tyson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply