• You can definitely query the management views (DMV) and there's also (from 2008) the MDW. A few articles on that here and on using it with SSAS here.

    Steve.