Report Portal

Script - SSAS Discover Current Processes

For the SQL Server database engine there is an Activity Monitor available in SSMS by default, for SSAS Analysis Services there is only a project "Activity Viewer" at CodePlex available; see links. In version 2008 of SSAS DMV (dynamic management views) where introduced, which can be used to query current connections and activities. Unfortunally you can't "join" 2 or more DMV in one MDX query to a get a complete overview at once.

This Powershell queries the SSAS DMV for current connections, session and commands and prompts the results as a formatted list to give a quick overview of activities. Additional it returns an overview with cummulated values like count of session, total send bytes and so on.

Tags: management, amo, powershell, scrtip


2007-2015 VidasSoft Systems Inc.