Sorry, forgot to add the caveat that Trace may not be available in Azure. I believe X-Events are, but I am not in position to give a demo to set up an X-event session that captures the query plan. And, since it is resource consuming, it possible that this particular event is not available on Azure.
Then again, why you would retrieve the query plan only to get the actual parameters?
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment