- You are experiencing frequent deadlocks in PI Performance Monitor table SAPSR3DB.XI_AF_PROF_PERF_AC
- Running update statistics or sp_recompile greatly improves performance, but for only a short time
- Sample SQLText involved in deadlock from sybase log:
Deadlock Id ## detected
SQL Text: DELETE FROM "XI_AF_PROF_PERF_AC" WHERE "PERIOD_TYPE" = ? AND "BEGIN_TIMESTAMP" < ?
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS)
- NetWeaver (NW) 7.4
- NetWeaver (NW) 7.5
deadlock, deadlocks, SAPSR3DB.XI_AF_PR, PI_BASIS, recompile, SQL1205, recompile_factor, volatile table, performance, hang, hanging , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this pageThis 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.