Users were using below transaction in DIA mode and executing reports during month End:
we found performance issue due to:
->Huge number of lock entries (around 5K to 6K) found in SM12 ( by same user )
-> All DIA/BGD work processes are occupied in few Application servers
->Found few long running jobs, without any progress.
So Please help us to understand, how a single user can make 5000 to 6000 lock entries in production system.
And also, please guide us to prevent this in future.