master..syslocks vs master..monLocks
Should we expect huge performance differences between syslocsk and monLocks when we large number of locks ?
select count(*) from syslocks
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 ?