Skip to Content
0

Can SAP Adaptive Server Cockpit monitor SQL statement and stored proc execution times?

May 08, 2017 at 03:57 PM

91

avatar image

Can SAP Adaptive Server Cockpit monitor SQL statement and stored proc execution times? (in addition to resources used by the SQL statement and stored proc executions)

This is assuming the use of the statement cache is enabled and 'enable literal autoparam' is on.

And I thought I remember seeing somewhere that an extra license might be required for this, but I can't find that now.

The web page under help.sap.com -> SAP Adaptive Server Enterprise -> SAP Adaptive Server Enterprise Cockpit -> Monitor SAP ASE -> Monitor SQL Queries at:

https://help.sap.com/viewer/9623e59098a24dc6b9013ba5d709309e/16.0.2.5/en-US/1b426ac3ac6310148bfc879883387664.html

just says:

"The SQL Activity window lists queries executed during the current trend period, along with details, including ...snip.. execution statistics."

Does "queries" include cached SQL statements with literalized autoparams? Does it include stored procs? Does it include execution time? Can this info be gathered without having a window open? Is the collected data kept in a repository that can be queried using SQL? Can it collect average/stddev/min/max per unit time? (ie. not stored millions of individual execution records)

Thanks in advance
Ben

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers