Настройка SSAS Extending Events

https://blogs.msdn.microsoft.com/analysisservices/2015/09/22/using-extended-events-with-sql-server-analysis-services-2016-ctp-2-3/

https://codingsight.com/extended-events-for-ssas/

https://blog.crossjoin.co.uk/2016/04/18/profiler-extended-events-and-analysis-services/

https://www.brentozar.com/extended-events/

Скрипты

1. Мониторинг запросов

<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ObjectDefinition>
    <Trace>
      <ID>MDX Long Queries</ID>
      <Name>MDX Long Queries</Name>
      <XEvent xmlns="http://schemas.microsoft.com/analysisservices/2011/engine/300/300">
        <event_session name="MDX Long Queries" dispatchLatency="0" maxEventSize="0" maxMemory="4" memoryPartition="none" eventRetentionMode="AllowSingleEventLoss" trackCausality="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
          <event package="AS" name="QueryEnd" />
          <target package="package0" name="event_stream" />
          <target package="package0" name="event_file">
            <parameter name="filename" value="E:\XE\MDX Long Queries.xel" />
            <parameter name="max_file_size" value="4096" />
            <parameter name="max_rollover_files" value="1" />
            <parameter name="increment" value="1024" />
          </target>
        </event_session>
      </XEvent>
    </Trace>
  </ObjectDefinition>
</Create>