topic Re: Is there a way to get execution plans for MSSQL in Dynatrace Cloud? in Extensions

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

soconnell — Thu, 05 Jun 2025 13:18:50 GMT

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

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

Mike_L — Thu, 14 Nov 2019 18:18:02 GMT

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

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

soconnell — Thu, 14 Nov 2019 18:23:52 GMT

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

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

Mike_L — Thu, 14 Nov 2019 23:15:29 GMT

Probably next year.

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

Roman_F — Fri, 25 Jun 2021 11:25:44 GMT

Is there any update on this?

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

Mike_L — Fri, 25 Jun 2021 11:53:03 GMT

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

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

Bill_Demsky — Sun, 27 Jun 2021 15:55:13 GMT

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.

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

Tom_Eaton — Thu, 07 Mar 2024 14:52:26 GMT

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