表现
某个操作或者JOB很慢,SM66发现锁操作耗时比较久,如果是循环内表执行操作、时间必然线性增加。
跟踪程序发现是包含文件LSENAF01中C CALL调用底层模块C_ENQUEUE耗时很长。
分析思路
https://answers.sap.com/questions/12304605/work-processes-going-in-enq-and-system-is-getting-.html
思路1:
Hi Musa, SM66: workprocess Running ENQ SAPLSENA which means that the workprocess has sent enqueue request to ENQ server, but there is no response from ENQ server yet. I suppose that you are using ASCS standalone enqueue server. the possible causes are: 1, ENQ server problem => if so, you should find some errors from dev_enq* trace file 2, network issues which block communication between DI and ENQ server => you can ask you network admin to troubleshooting it when issue is happening again 3, are you enable ERS server ? it could be synchronize problem between ENQ server and ERS server => you can just try to disable ERS server and check again Since this issue happens once in every month, does this issue occur on the same period every time ? what did you perform during that period every month ? Probably the special actions which performed every month cause this issue(see possible reasons above). Thanks and best regards, Shi |
思路2:
检查锁相关的参数设置,注意需要检查的是ASCS(CI)服务器而不是DI。
enque/table_size = 500000 enque/snapshot_pck_ids = 1600 enque/server/max_query_requests = 15000 enque/server/max_requests = 5000 enque/server/max_clients = 1500 enque/async_req_max = 5000 enque/server/threadcount = 4 install/codepage/appl_server = 8400 rdisp/enqname = $(rdisp/myname) enque/server/replication = true ipc/shm_psize_40 = 484000000 |
系统日志分析:
/usr/sap/S4P/ASCS00/work下面的enq相关文件,ls -lrt排序,查看最新的文件。
本文作者: GavinDong
版权属于: GavinDong博客
文章链接: https://gavindong.com/4015.html
如果使用过程中遇到问题,可 **点击此处** 交流沟通。
版权所有,转载时必须以链接形式注明作者和原始出处及本声明。