Silent SSAS shutdown caused by writeback timeout

A number of customers using SSAS instances with writeback functionality reported frequent crashes that were not accompanied by any useful error message. The only hint found in msmdsrv.log close to time of crash was: (03.04.2016 13:30:21) Message: OLE DB-Fehler: OLE DB- oder ODBC-Fehler : Query timeout expired; HYT00. (Source: \\?\J:\Log\msmdsrv.log, Type: 3, Category: 289, Event…


uninstall of clustered SSAS instance may disable “olap redirection service”

  “OLAP redirection service” is the part of SQL browser service that supports SSAS connectivity. If you stick to our recommendation to only use “virtual server name” for connecting to clustered SSAS instances (see previous post: http://blogs.msdn.com/b/as_emea/archive/2014/01/08/connecting-to-clustered-ssas-instances.aspx), then you won’t need the “olap redirection service”. However, we are aware that there are some situations where…


"Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014" has been released

Thanks to the efforts of our US support colleagues Karan Gulati and Jon Burchel we now have an updated version of the SSAS performance guide available.  The “Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014” document can be downloaded from MSDN via the following link: http://msdn.microsoft.com/en-us/library/dn749781.aspx As the name suggests it contains advice…


How to connect to clustered Analysis Services instances

While clustered SSAS instances have been around for a while, we noted that there is still some confusion about the recommended way for connecting to clustered instances and our supportability policy. Let’s start with the hopefully well known behavior for non-clustered SSAS instances. Stand-alone Instances All default SSAS instances will listen on port tcp 2383….


1 hour timeout for data refreshes in Powerpivot for Sharepoint

In the previous blog post I explained that we have a 1 hour timeout in Powerpivot for Excel due to the inherited default SSAS instance properties. Now you might argue that this timeout should not pose a problem in the Powerpivot for Sharepoint environment. After all we are using a standalone SSAS instance in Sharepoint mode….


Issues with using msolap.x provider name in linked server definition

During a recent investigation I realised that a number of people are using MSOLAP.x as the provider name for a linked server e.g. MSOLAP.4 when creating a linked server… e.g. EXEC master.dbo.sp_addlinkedserver @server = N’lsname’, @srvproduct=N’msolap’, @provider=N’MSOLAP.4′, @datasrc=N’servera\inst’, @catalog=N’SSASDBName’ /* For security reasons the linked server remote logins password is changed with ######## */ EXEC…


Profiling SSAS : where have my milliseconds gone ?!?

Hi Everyone, A short post to illustrate a pattern which I only recently clarified. Ever wondered why your “time” columns in a SSAS profiler trace had all .000 values for milliseconds (therefore giving you only a precision level of a second) ?   Well this seems to happen when it is the Profiler tool that…


Data collection for troubleshooting Analysis Services issues

Today’s blog will cover the types of logs/data that we typically request when investigating Analysis Services issues. Most of these logs (excluding dumps) are easily readable and you can use them for your own investigation. MS support uses a number of  tools (mps reports, Support Diagnostic Platform, pssdiag, sqldiag) for automated data collection. Unfortunately these…