Query consumes all available server memory - by Jim Fernandez

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 786118 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/2/2013 8:57:04 AM
Access Restriction Public

Description

Our configuration: SSAS 2012 Enterprise (11.0.3349.0), Win Server 2012, 8 core, 254 Gb RAM
 
The following simple query that utilizes a VB function will consume all available memory within a few minutes, forcing a restart of services to free up resources.  
 
WITH MEMBER A AS Value("03/28/2013")
SELECT {A} ON 0
FROM [Adventure Works]
 
Thanks,
Jim
Sign in to post a comment.
Posted by Microsoft on 1/9/2014 at 12:47 PM
this issue will be fixed in next service pack. Please note that member function is not supported with DAX/Tabular model so it supposed to give an error instead of running out of stack.
This new behavior is incorporated in the next service pack.
Posted by Microsoft on 10/1/2013 at 11:02 PM
Hi Jim,
Thanks for submitting the issue. We are working on it.
Posted by Jim Fernandez on 6/1/2013 at 9:28 AM
any activity on this issue?