Skip to content

byoBI.com

SSAS, Power BI, etc

  • Blog
  • About
  • Consulting

Tag: Performance

What is Super DAX?

Bill 2017-08-28

In a recent post, I mentioned something called Super DAX without giving it a very detailed explanation. If you’ve been working with SSAS for a few years and have a couple of Tabular projects under … Continue reading What is Super DAX? →

Analysis Services Tabular Is (Finally) NUMA-Aware!

Bill 2016-11-16

Wow, right on the heals of Azure AS and just when you thought things couldn’t get any better for SSAS geeks of the world… Microsoft releases SP1 for SQL Server 2016… an voila, Tabular is … Continue reading Analysis Services Tabular Is (Finally) NUMA-Aware! →

How to Detect Locking and Blocking In Your Analysis Services Environment

Bill 2016-09-20

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 … Continue reading How to Detect Locking and Blocking In Your Analysis Services Environment →

Choosing the Right Instance in Perfmon

Bill 2016-09-02

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 … Continue reading Choosing the Right Instance in Perfmon →

Performance Monitoring for SSAS – Extended Events Cheat Sheet

Bill 2016-02-11

Welcome back! This is the 3rd post in a series of posts focusing on performance monitoring for Analysis Services. Performance Monitoring for SSAS – Intro Performance Monitoring for SSAS – Data Collection Performance Monitoring for … Continue reading Performance Monitoring for SSAS – Extended Events Cheat Sheet →

Performance Monitoring for Analysis Services – Data Collection

Bill 2015-12-21

Welcome back! This is the second post in a series of posts focusing on performance monitoring for Analysis Services. Performance Monitoring for SSAS – Intro Performance Monitoring for SSAS – Data Collection Performance Monitoring for SSAS … Continue reading Performance Monitoring for Analysis Services – Data Collection →

3 Methods for Shredding Analysis Services Extended Events

Bill 2015-12-03

Troubleshooting Analysis Services performance issues is hard. In complex and/or high concurrency environments (e.g. scale-out solutions) it can be a nightmare. Throw in a transient issue (i.e. one that can’t be reproduced on command or … Continue reading 3 Methods for Shredding Analysis Services Extended Events →

Performance Monitoring for Analysis Services – Part1

Bill 2015-09-03

One of the really cool benefits of being a Linchpin Teammate, besides working with some wicked smart SQL-people, is getting to participate in the Notes From the Field series over at site SQLAuthority.com. Note: SQLAuthority.com … Continue reading Performance Monitoring for Analysis Services – Part1 →

PSA: Stop Putting Sorts in SSIS Data Flows…

Bill 2015-08-11

…or any fully-blocking transforms for that matter.   SSIS 101 The primary function of SSIS is to move data from location A to location B with the option of performing transformations to the data along … Continue reading PSA: Stop Putting Sorts in SSIS Data Flows… →

MDX Script: Calculated Members (vs Named Sets)

Bill 2015-02-17

In the previous blog post I discussed the benefits of defining MDX calculations in the cube (instead of in the query using the WITH-clause). The primary benefit was having named sets computed ahead of time … Continue reading MDX Script: Calculated Members (vs Named Sets) →

Posts navigation

← Older Posts

Recent Posts

  • A Few Thoughts on Power BI and the Future
  • Programmatically Deploy Power BI Reports to Power BI Report Server
  • Implementing As Partition Processing via Azure Functions–Part 2
  • Implementing AS Partition Processing via Azure Functions
  • Enriching your Power BI Solutions with Metadata

Tags

Architecture Automation Azure AzureAS Azure Functions Big Data Books Certification ColumnStore Index Compression Data Mining Data Visualization Data Warehouse DAX Dimensional Modeling Excel 2013 Extended Events Facebook Hardware Licensing MDS MDX Performance PerformancePoint Services Performance Tuning Power BI PowerPivot PowerShell Power View Predictive Analytics Presenting Self-Service BI Sharepoint 2010 Social Graph SQLSaturday SQL Server 2012 SSAS SSDT SSIS SSRS Statistics T-SQL Tabular Troubleshooting Visual Studio

Recent Tweets…

My Tweets

Archives

  • October 2018 (1)
  • April 2018 (2)
  • March 2018 (1)
  • November 2017 (3)
  • August 2017 (5)
  • May 2017 (4)
  • February 2017 (2)
  • January 2017 (1)
  • December 2016 (1)
  • November 2016 (5)
  • October 2016 (1)
  • September 2016 (3)
  • August 2016 (2)
  • July 2016 (3)
  • June 2016 (2)
  • May 2016 (1)
  • April 2016 (2)
  • March 2016 (4)
  • February 2016 (1)
  • January 2016 (2)
  • December 2015 (3)
  • November 2015 (1)
  • October 2015 (3)
  • September 2015 (4)
  • August 2015 (2)
  • June 2015 (3)
  • May 2015 (2)
  • April 2015 (2)
  • February 2015 (3)
  • January 2015 (2)
  • November 2014 (1)
  • October 2014 (1)
  • September 2014 (1)
  • August 2014 (1)
  • June 2014 (3)
  • May 2014 (5)
  • April 2014 (2)
  • March 2014 (2)
  • February 2014 (4)
  • January 2014 (5)
  • December 2013 (2)
  • November 2013 (1)
  • October 2013 (6)
  • September 2013 (4)
  • August 2013 (4)
  • July 2013 (6)
  • June 2013 (3)
  • May 2013 (3)
  • April 2013 (5)
  • March 2013 (6)
  • February 2013 (4)
  • January 2013 (2)
  • December 2012 (6)
  • November 2012 (5)
  • October 2012 (4)
  • September 2012 (2)
  • August 2012 (8)
  • July 2012 (1)