Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

master..syslocks vs master..monLocks

Should we expect huge performance differences between syslocsk and monLocks when we large number of locks ?

We ran

     select count(*) from syslocks

and

     select count(*) from monLocks

Both returned  200,000 rows

The first took          1s

The second took     25s

Is monLocks performance much slower than syslocks ?

Is there a way to improve the performance of the mon tables ?

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question