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],[…]
Read moreDrive Into Data
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],[…]
Read more