SAP Knowledge Base Article - Preview

2358573 - raudit_spin spinlock and its impact on performance - SAP ASE

Symptom

  • Observing performance slowness.
  • The spinmon report shows high numbers for the "raudit_spin" count, for example:

 spinlock                                                                               grabs       waits       wait_percent spins_per_wait total_spins spins_per_xact
 -------------------------------------------------------------------------------------- ----------- ----------- ------------ -------------- ----------- ---------------------------
 Resource->raudit_spin::0                                                                  35934985     7072472           19             23   163964241                 2648.215150
 Kernel->kmspinlock::0                                                                      1333485       81740            6            162    13273263                  214.378794
 Kernel->kpsleepqspinlock[i]::0                                                             7538567      335914            4             15     5049970                   81.562949
......

  • What does the "raudit_spin" spinlock do?
  • How does it impact the ASE performance?

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Freelist, Manager, contention, CPU Busy, sybsecurity, sysaudits, audit, queue, sizing ,security. memory , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.