Cached DAX query plans not showing up in profiler - by Gerhard Brueckl

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<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 780570 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/4/2013 5:20:27 AM
Access Restriction Public

Description

when executing a MDX query twice against a tabular database the "DAX query plan" event only shows up the first time 
I assume that the query plan gets cached and therefore does not show up a second time
this can be very annoying when tuning a query and trying to dig into the query plan
Sign in to post a comment.
Posted by Microsoft on 4/19/2013 at 11:50 AM
Thanks for your feedback. This behavior is "by design" because it is a performance optimization. You may be able to use real time OLAP = True on the connection string to get the behavior you want.

Thanks,
Analysis Services Product Team