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

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

BabarQayyum
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