SSAS Sessions Overview

Written by Olaf Helper. Posted in SSAS Scripts

This MDX statement queries the current session informations using the DMV DISCOVER_SESSIONS in a Transact-SQL query style with more user-friendly column names.

To get the most busy session you can order the result by Cpu usage, command count or read/write amount.