Problem: How to find blocking on SSAS Tabular server?
Solution:
Option1:
select *from $system.discover_locks where lock_status=0
Option2:
SELECT [SESSION_COMMAND_COUNT], [SESSION_CONNECTION_ID], [SESSION_CPU_TIME_MS], [SESSION_CURRENT_DATABASE], [SESSION_ELAPSED_TIME_MS], [SESSION_ID], [SESSION_IDLE_TIME_MS], [SESSION_LAST_COMMAND], [SESSION_LAST_COMMAND_CPU_TIME_MS], [SESSION_LAST_COMMAND_ELAPSED_TIME_MS], [SESSION_LAST_COMMAND_END_TIME], [SESSION_LAST_COMMAND_START_TIME], [SESSION_PROPERTIES], [SESSION_READ_KB], [SESSION_READS], [SESSION_SPID], [SESSION_START_TIME], [SESSION_STATUS], [SESSION_USED_MEMORY], [SESSION_USER_NAME], [SESSION_WRITE_KB], [SESSION_WRITES] FROM $SYSTEM.DISCOVER_SESSIONS where session_status=2