question

AmeshJeram avatar image
AmeshJeram asked

SSAS Cubes User Activity

Is it possible to join SSAS activities based on different DMV Tables? Scenario: Joining $system.DISCOVER_SESSIONS with $system.DISCOVER_Commands Example: select $system.SESSION_ID, $system.SESSION_SPID, $system.SESSION_USER_NAME, $system.SESSION_CURRENT_DATABASE, $system.SESSION_START_TIME, $system.SESSION_ELAPSED_TIME_MS, $system.SESSION_LAST_COMMAND, $system.SESSION_LAST_COMMAND_CPU_TIME_MS, $system.SESSION_COMMAND_COUNT, $system.COMMAND_START_TIME, $system.COMMAND_TEXT, $system.COMMAND_END_TIME FROM $system.DISCOVER_SESSIONS INNER JOIN $system.DISCOVER_Commands
ssascubesactivity-monitor
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I haven't done this specifically, but try *Use Dynamic Management Views (DMVs) to Monitor Analysis Services* on MSDN - http://msdn.microsoft.com/en-us/library/hh230820.aspx
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.