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