Data World

Posts Tagged ‘ssas’

SSAS-Find blocking onSSAS Tabular server

Posted by Pramod Singla on December 16, 2015


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

Posted in SSAS | Tagged: , , , | Leave a Comment »