SAP Knowledge Base Article - Preview

1977103 - When profiling a SQL Anywhere database with request logging and sa_get_request_times, sa_get_request_profile, or, the number of statement executions reported may be incorrect


  • When using request logging to gather an activity log on a database, the sa_get_request_profile() and sa_get_request_times() system procedures and the Perl script '' can be used to analyze and summarize the output of the request logging (dbsrv16 -zo).
  • In certain situations, the analysis summary reflects a lower number of statements executed (i.e. "uses" column in the temporary table satmp_request_profile, or the "Executions" value in the output) than what the client is expecting to have been analyzed at the database server.



SAP Sybase SQL Anywhere (all versions, all platforms)


SAP SQL Anywhere all versions ; SAP SQL Anywhere, cloud edition all versions ; SQL Anywhere all versions


11592370, request level logging , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.