Can you elaborate on the "serious side effects"?

The way I see it, if the server has sufficient memory, and one has some rough idea on how many row/page locks there...