Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers