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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.