SAP Knowledge Base Article - Preview

2358573 - Where can information on auditing, performance and the impact of raudit_spid be found - 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?
  • How can auditing be setup for the best performance and the least impact on the server?


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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

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.