…brew your own Business Intelligence

Posts Tagged ‘Tabular’

How Much RAM Do I Need For My SSAS Tabular Server?

Much of my client work these days is focused on performance… making slow Analysis Services servers run faster. The good part about these types of engagements is that there’s usually (not always) a good amount of low-hanging fruit and I get to play the hero that swoops in to save the day. The bad […]

Read more

SSAS Tabular: Scale-Out Query Architecture

Earlier this week, while discussing high-concurrency architecture options for SSAS multidimensional, a colleague asked about options for SSAS tabular and mentioned there was very little information available online specific to tabular…and so, a blog post is born. The short answer is that Scale-Out Query Architecture for Tabular is essentially identical […]

Read more

SQL Profiler EventClass & EventSubClass Column Descriptions for SSAS 2012

Lately, I’ve been spending quite a bit of time troubleshooting some performance issues related to PowerView reports running against a SQL Server Analysis Services 2012 Tabular data source.  One of the first steps in the troubleshooting process involved turning up a SQL Profiler trace on the SSAS Tabular instance and […]

Read more