…brew your own Business Intelligence


Latest Posts

  • I’ll Make Them an Offer They Can’t Refuse
    Over the past few weeks I’ve been flexing my network to try and get on an Azure DW project…and so far I’ve come up empty handed. Now granted, I could definitely be wrong about this… but I *thought* my offer was overly generous and guaranteed to land me on an Azure...
    Read more
  • How to Detect Locking and Blocking In Your Analysis Services Environment
    This past weekend, after one of my presentations on Analysis Services at SQL Saturday 520, an attendee described a performance issue in his environment that he thought could be related to locking and blocking and asked if there was a way to confirm if this was the cause. The short...
    Read more
  • Choosing the Right Instance in Perfmon
    There’s been quite a bit posted on this blog regarding the collection of perfmon counters to monitor Analysis Services instances and troubleshoot performance problems. And some of the recommended perform counters (e.g. Process: % Processor Time) are “instance”-specific… meaning you need to select the name of the process for which...
    Read more
  • 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...
    Read more
  • Analysis Services Extended Events – AutoRestart Option
    The MSDN documentation and SSMS support for Analysis Services xEvents is severely lacking when compared to the database engine. In fact there wasn’t even a GUI for SSAS xEvents until SQL 2016… which meant anyone who wanted to create an xEvents trace had to craft another cryptic XMLA command. To...
    Read more
PASS Summit 2016