How to build your own SSAS Resource Governor with PowerShell
few weeks ago I posted a way to manually find and kill long running SSAS queries. In this post I'll take it a step further and show you an automated solution. The idea behind this technique is inspired by a blog post Chris Webb did some years ago. Chris implemented his solution using SSIS while this version uses PowerShell.
Read more...Tags: management, amo, script, powershell