cancel
Showing results for 
Search instead for 
Did you mean: 

Stopping Lock table overflow before it starts

Former Member
0 Kudos

Hello all,

Anyone know of any technique where we as basis can find out if many locks are being used before its too late and everything starts failing? I am looking to develop a solution where if the system is using say more than 30,000 locks(given that we have 2app servers + CI), it would alert us by sending us a mail.

i am thinking, i can modify the program which runs transaction SM12 to look for locks every 5 minutes or so and if the locks exceed certain amount then it alerts us, but this may be crude and resource consuming.

anyone out there using anything different?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Find out the cause of locks , it might be some jobs , user etc etc .. For monitoring check the CCMS , there might be a MTE which will help you to monitor the locks ...

Thanks

Prince Jose

Former Member
0 Kudos

Hi

30000 locks entries is too excess. It needs to be addressed soon. Get the Early Watch done and fine tune as recommended.