|
Script - SSAS Discover Current Processes |
|
Written by Olaf Helper
|
|
Sunday, 08 January 2012 18:56 |
|
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.
|
