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.

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


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 Howie [MSFT] 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.

Analysis Services Product Team