The SSAS DMVs can be used to track measure usage and statistics. These can be queried from any tool that can be used to submit DAX or MDX queries. For example, by connecting to SSAS through SSMS and opening a new query editor window (click on the cube name and press CTRL + N
). The following objects can be queried just as a table in SQL would be. The documentation contains more details on the specifics of what each column means. The last two DMVs (DISCOVER_COMMANDS
and DISCOVER_SESSIONS
) include details about what measures were used in the COMMAND_TEXT
and SESSION_LAST_COMMAND
columns, respectively.
Reads, Writes, Number of Times Object Hit in Cache and Similar Stats:
$SYSTEM.DISCOVER_OBJECT_ACTIVITY
Memory Usage:
$SYSTEM.DISCOVER_OBJECT_MEMORY_USAGE
Measure Details:
$SYSTEM.MDSCHEMA_MEASURES
Track Submitted Commands:
$SYSTEM.DISCOVER_COMMANDS
Monitor Sessions:
$SYSTEM.DISCOVER_SESSIONS