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

This product reached the end of support date on March 31, 2021.

The DB did not return any explain plan for the query

asruinoiua
Contributor

Hi,

My problem is the connection between Application Server and MSSQL Server is very slow (>20s) in the purepaths. My MSSQL server is using Store Procs. But when i go to "Show SQL Excution Plan" on slow query, error:

How to i analysis query inside Store Procerdure?

Hope you can help me!

1 REPLY 1

Babar_Qayyum
DynaMight Leader
DynaMight Leader

Hello Asrui,

A query execution plan is the optimized set of steps used to access data in a SQL relational database management system. It is retrieved from the database cache on demand and is not stored in AppMon.


  • If the DB cache has been cleared, prior execution plans are not available.
  • In order to request an execution plan the user must have the DB permission to view SQL statements and the AppMon one (Settings menu > Dynatrace Server > Settings item > Confidential Strings horizontal tab ) to view confidential strings.
  • Using the jTDS driver for MSSQL enabling query preprocessing (JtdsStatement.setEscapeProcessing() method) may cause problems with looking up query execution plans as the query text gets modified.

https://www.dynatrace.com/support/doc/appmon/database-monitoring/sql-execution-plan/

Regards,

Babar