November 20, 2014 at 1:13 pm
Hi,
Is there a way to find when each of the dimensions and partitions finished processing. Is there Some kind of SQL profiler on the SSAS server.
I have a cube with oracle as back end. And I am not sure which part of the cube processing is slow. Please suggest.
Thanks.
Veena
November 20, 2014 at 1:27 pm
Should be able to use the DMV's if you're on 2008+
http://msdn.microsoft.com/en-us/library/hh230820(v=sql.110).aspx
Steve.
November 21, 2014 at 3:24 am
stevefromOZ (11/20/2014)
Should be able to use the DMV's if you're on 2008+http://msdn.microsoft.com/en-us/library/hh230820(v=sql.110).aspx
I'm not sure there is a DMV with processing information.
Bob Duffy has an excellent session on tuning SSAS processing and how you can monitor this and where to optimize.
You can download it from the SQLBits website:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 21, 2014 at 8:57 am
Thank you Koen and Steve. This is very helpful. I will try the suggestions from the session using profiler. The back end is Oracle . I am not sure how much information will be able to see and understand from running the profiler on the SSAS server.
November 21, 2014 at 9:14 am
As is often the case, you're right Koen, but I'm also a little right... 😉 I looked only at the CUBES rowset, which *does* have the datetime of last processing (as per the OP requirement, they wanted to know when it finished) but the dimensions rowset doesn't and i don't think there even *is* a partitions rowset.
Oh, and voted for you today re: your LI post re: author of the year.:-D
Steve.
November 22, 2014 at 9:03 am
stevefromOZ (11/21/2014)
As is often the case, you're right Koen, but I'm also a little right... 😉 I looked only at the CUBES rowset, which *does* have the datetime of last processing (as per the OP requirement, they wanted to know when it finished) but the dimensions rowset doesn't and i don't think there even *is* a partitions rowset.
You're absolutely right. I use that DMV as well in my reports to indicate how "fresh" the data is 🙂
Unfortanately there are no detailed DMVs about processing. How long it took to read the data, how long it took to build the indexes and aggregations and so on...
stevefromOZ (11/21/2014)
Oh, and voted for you today re: your LI post re: author of the year.:-D
Thanks 😎
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply