Symptom
- Stored Procedures are executed from a front end application with execute immediate
- sp_sysmon show high cpu usage
Engine Utilization (Tick %) User Busy System Busy I/O Busy Idle
------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_default_pool
Engine 0 98.9 % 0.0 % 0.2 % 0.9 %
Engine 1 99.0 % 0.0 % 0.2 % 0.8 %
Engine 2 98.5 % 0.0 % 0.3 % 1.2 %
Engine 3 99.5 % 0.0 % 0.2 % 0.3 %
Engine 4 98.4 % 0.0 % 0.3 % 1.2 %
Engine 5 99.4 % 0.0 % 0.2 % 0.4 %
Engine 6 99.3 % 0.0 % 0.2 % 0.6 %
Engine 7 99.2 % 0.1 % 0.2 % 0.5 %
------------------------- ------------ ------------ ---------- ----------
Pool Summary Total 792.2 % 0.1 % 1.7 % 6.0 %
Average 99.0 % 0.0 % 0.2 % 0.7 %
- Dedicated cache bound to syscolumns shows high spinlock contention
Cache: <database>_syscolumns
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 55.8 %
Utilization n/a n/a n/a 78.2 %
Cache Searches
Cache Hits 11414.5 181.5 1369739 100.0 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 11414.5 181.5 1369739
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
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.