Home Dashboard Directory Help
Search

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


Status: 

Closed
 as By Design Help for as By Design


1
0
Sign in
to vote
Type: Bug
ID: 780570
Opened: 3/4/2013 5:20:27 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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
Details
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
Sign in to post a workaround.