Symptom
- Replay from Workload Analyzer (WLA) is showing large number of errors in analysis report
- The Total Count in Errors show 62,717,403 for each error number, but the number of errors displayed in the list is only about 51,000
- Based on the sp_sysmon and hotbufs are showing high usage of sysmessages
SYSMON:
Cache: Default Data Cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 4.9 %
Utilization n/a n/a n/a 4.2 %
Cache Searches
Cache Hits 38614.9 4.9 1158446 100.0 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 0.0 0.0 0 0.0 %
HOTBUF:PRINTING HOT BUFFERS for Data Cache :default data cache in Descending Order at the Cache Level.
1. pageno=1442 dbid=1 ptnid=36 indid=0 objname=sysmessages version=1 cache_spin=44555568 buf_spin=0
2. pageno=329 dbid=1 ptnid=36 indid=1 objname=sysmessages version=1 cache_spin=38577640 buf_spin=0
3. pageno=1441 dbid=1 ptnid=36 indid=0 objname=sysmessages version=1 cache_spin=3673611 buf_spin=0
4. pageno=1970 dbid=1 ptnid=36 indid=0 objname=sysmessages version=1 cache_spin=174926 buf_spin=0
- Based on the sp_sysmon and hotbufs are showing high usage of sysmessages
- The 62 million seems to be correct, but the details in the Error report is not reflecting all the information.
- Application Report is showing that there is clearly issues with some of the applications, if all the errors are added up from the “number of errors” reported the result is exactly what is being reported in the Error section.
- Sessions also adds up to the same 62,716,403 in the “number of errors” column
Read more...
Environment
SAP Adaptive Server Enterprise 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.