{"id":821,"date":"2015-12-16T19:33:58","date_gmt":"2015-12-16T14:03:58","guid":{"rendered":"http:\/\/pramodsingla.com\/?p=821"},"modified":"2015-12-16T19:33:58","modified_gmt":"2015-12-16T14:03:58","slug":"ssas-find-blocking-onssas-tabular-server","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=821","title":{"rendered":"SSAS-Find blocking onSSAS Tabular server"},"content":{"rendered":"<p style=\"text-align:justify;\"><span style=\"color:#ff0000;\"><strong>Problem: <\/strong><\/span>How to find blocking on\u00a0SSAS Tabular server?<\/p>\n<p><span style=\"color:#008000;\"><strong>Solution:<\/strong><\/span><\/p>\n<p><strong>Option1:<\/strong><\/p>\n<blockquote>\n<pre>select *from $system.discover_locks \u00a0where lock_status=0<\/pre>\n<\/blockquote>\n<p><strong>Option2:<\/strong><\/p>\n<blockquote>\n<pre>SELECT\n[SESSION_COMMAND_COUNT],\n[SESSION_CONNECTION_ID],\n[SESSION_CPU_TIME_MS],\n[SESSION_CURRENT_DATABASE],\n[SESSION_ELAPSED_TIME_MS],\n[SESSION_ID],\n[SESSION_IDLE_TIME_MS],\n[SESSION_LAST_COMMAND],\n[SESSION_LAST_COMMAND_CPU_TIME_MS],\n[SESSION_LAST_COMMAND_ELAPSED_TIME_MS],\n[SESSION_LAST_COMMAND_END_TIME],\n[SESSION_LAST_COMMAND_START_TIME],\n[SESSION_PROPERTIES],\n[SESSION_READ_KB],\n[SESSION_READS],\n[SESSION_SPID],\n[SESSION_START_TIME],\n[SESSION_STATUS],\n[SESSION_USED_MEMORY],\n[SESSION_USER_NAME],\n[SESSION_WRITE_KB],\n[SESSION_WRITES]\nFROM \n$SYSTEM.DISCOVER_SESSIONS\nwhere session_status=2<\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Problem: How to find blocking on\u00a0SSAS Tabular server? Solution: Option1: select *from $system.discover_locks \u00a0where lock_status=0 Option2: SELECT [SESSION_COMMAND_COUNT], [SESSION_CONNECTION_ID], [SESSION_CPU_TIME_MS],[&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[60,108,175,178],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/821"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=821"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/821\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}