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!
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.
JtdsStatement.setEscapeProcessing()method) may cause problems with looking up query execution plans as the query text gets modified.