Managing Your Azure AS Environment with PowerShell – Building Blocks

One of the major value propositions of Azure AS (and this is true for many cloud technologies) is flexibility – spinning up more resources when demand spikes and turn things off when they aren’t – so that you’re only paying for what you need. In order to take advantage of this flexibility, we need to […]

Managing Your Azure AS Environment with PowerShell – Getting Started

One of the major value propositions of Azure AS (and this is true for many cloud technologies) is flexibility – spinning up more resources when demand spikes and turn things off when they aren’t – so that you’re only paying for what you need. Consider your own Analysis Services environment. If it’s anything like the […]

Load Testing SSAS with PowerShell

Load testing an SSAS database is one of those tasks that everyone should be doing but very VERY few people actually do… and I can only suspect the reason is because it’s hard. Here are the general steps involved: Capture the query workload using an xEvents (basic example, autorestart option) Shred the xEvents trace file(s) and load queries […]

PowerShell: Checking For Large SSAS String-Store Files

In a recent blog post, Why You Need to Routinely ProcessFull, I discussed an issue where we’d run into the 4GB file size limit on SSAS string store files. In an ideal world, we’d fully reprocess the SSAS databases on a regular basis which would eliminate this issue…and maybe even provide a (very) minor performance […]