Press enter to see results or esc to cancel.

Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet

Welcome back! This is the 4th 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 – Extended Events Cheat Sheet Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet Performance Monitoring for SSAS – …

Continue reading

Performance Monitoring for SSAS – Extended Events Cheat Sheet

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 SSAS – Extended Events Cheat Sheet Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet Performance Monitoring for SSAS – …

Continue reading

Performance Monitoring for Analysis Services – Data Collection

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 – Extended Events Cheat Sheet Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet Performance Monitoring for SSAS – Extracting …

Continue reading

DAX: Performance Gains via Aliases and Variables

  Consider the following DAX snippet: SWITCH ( TRUE() ,SUM(‘Internet Sales'[Sales Amount]) > 1000000, “A” ,SUM(‘Internet Sales'[Sales Amount]) > 100000, “B” ,”C” ) Very straightforward, right? If the sum of sales amount is > 1mm, return “A”… if its between 1mm and 100k, return “B”… otherwise, return “C”. Note: SWITCH-statements are merely syntactic sugar. Under the …

Continue reading