cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

soconnell
Newcomer

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)?


6 REPLIES 6

Mike_L
Dynatrace Leader
Dynatrace Leader

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


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


Mike_L
Dynatrace Leader
Dynatrace Leader

Probably next year.


Roman_F
Frequent Guest

Is there any update on this? 

Mike_L
Dynatrace Leader
Dynatrace Leader

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

Bill_Demsky
Helper

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.