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.
SAP Knowledge Base Article - Preview