Is there a way to get execution plans for MSSQL in Dynatrace Cloud?

[soconnell]

Currently I am trying to find out if there is a way for me to pull the execution plan of a query down or visualize it in the Dynatrace hosted solution. Is there a plugin for Activegate (i didn't see one but totally could have missed it)?

[Mike_L · Accepted solution]

Hi,

There is currently no such functionality for MSSQL. For Oracle that is something that is part of the database insights. A similar database insight product is also planned for MSSQL

Mike

[soconnell]

Thanks Mike! you happen to be privy to any kind of eta at all on that?

[Mike_L]

Probably next year.

[Roman_F]

Is there any update on this? 

[Mike_L]

Not yet, with extension framework 2.0 the roadmap shifted somewhat. @dglugla has the new database extensions on his radar.

[Bill_Demsky]

Please consider logging the SQL statements even without query plans. This would allow us to get the problem statement based on duration, capturing the bind variables would be a plus to we can see the parameters of the statement.

[Tom_Eaton]

https://community.dynatrace.com/t5/Product-ideas/RFE-need-execution-plan-for-SQL-extension/idi-p/197... - it is planned, the work for this, has already started (today!)