PowerShell Scripts for Collecting SSAS-related Perfmon and xEvent Trace Data

Here are two more PowerShell scripts I've been using for a while now to collect SSAS-related performance data. Each script is structured as a PowerShell function w/ a single call at the bottom of the script so that they can be executed ad-hoc. One cool thing about these scripts is that they're SSAS-mode agnostic. Basically the script connects to the instance, determines the mode (i.e. Tabular or Multidimensional) and then collects counters/events specific to the SSAS-mode. For example, there's not a lot of value (in most cases to collect disk/IO counters for SSAS-Tabular instances).

Read more...