Fix: Analysis Services crashes while processing the TFS OLAP cube

I was on-site with a customer last week performing a Team Foundation Server Health Check (TFSHC). While I was there, I noticed that their SQL Server Analysis Services 2008 R2 SP1 instance had been crashing. So, I did what any good PFE would do and grabbed a copy of the crash dumps (SQLDmpr0001.mdmp) and analysed…