SAP Knowledge Base Article - Preview

2590282 - High SSQLCACHE_SPIN in spinlock contention when update to a column with numeric datatype

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.