FIX: Runaway MDX query that uses Value() function in SSAS 2014 can rapidly and completely consume all the server memory and cause the server to hang

Applies to: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core

Symptoms


Assume that you are using Microsoft SQL Server 2014 Analysis Services (SSAS 2014). When Value() function is not appropriately used in an MDX (Multidimensional expressions) query, the query may rapidly and completely consume all the server memory even beyond memory limitation. Therefore, this may cause the server to hang.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 5 for SQL Server 2014 SP2

 

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section

References


Learn about the terminology that Microsoft uses to describe software updates.