Symptom
- Observed very high SSQLCACHE_SPIN spinlock contention as well as slow performance and high CPU.
- dbcc prsqlcache show duplicate update statements in the same hash bucket. Each supdate statement has different precision and scale of the numeric column along with a mixture of nulls for some column.
- Here is a portion of dbcc prsqlcache output:
Bucket# 5655, Entry Count: 4666, address 0x0x2aaec1b821c0
Empty Bucket Ct: 7810, Maximum Entries In Bucket# 5655: 4666, Avg. Entries Per Bucket: 0.735686, Std. Dev.: 51.829462
The same update statement looks like the following are all in the same bucket:
SQL TEXT: update stmt_cache_test set col_01=@p0, col_02=@p1, col_03=@p2,
col_04=@p3, col_05=@p4, col_06=@p5, col_07=@p6, col_08=@p7, col_09=@p8,
col_10=@p9 where pkey=@p10
ssql_obdcl: (@p10 INT output, @p0 NUMERIC(20, 8) output, @p1 NUMERIC(20, 6)
output, @p2 NUMERIC(20, 1) output, @p3 NUMERIC(20, 1) output, @p4 NUMERIC(20, 5)
output, @p5 NUMERIC(20, 6) output, @p6 NUMERIC(20, 9) output, @p7 NUMERIC(20, 1)
output, @p8 NUMERIC(20, 5) output, @p9 NUMERIC(20, 8) output)
Read more...
Environment
- Adaptive Server Enterprise 16
- Adaptive Server Enterprise 15.7
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR812823,update,numeric,procedure cache,dynamic sql , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.