SAP Knowledge Base Article - Preview

3445837 - Feature request to improve sp_serverinfo peformance - SAP ASE

Symptom

  • Client driver calls sp_serverinfo to fetch the server or client character set and sort order information.
  • With large number of connections, the call to sp_serverinfo accumulates high logical reads on the syscurconfigs table.
  • Here's metrics from a day's worth of:
    exec sp_serverinfo server_csname'
    exec count        logical reads           cpu_time          exec_time           avg_Lio          avg_cpu
    415,886,791    324,203,889,784     74,909,990       134,106,167        779.55           0.180121 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.