Report Portal

SSAS Sessions Overview

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.


Tags: mdx, management, script, dmv


2007-2015 VidasSoft Systems Inc.