What are the considerations for selecting the lock granularity level?

Selecting the lock granularity level is a trade-off between concurrency and resources.

Using a higher lock granularity results in a lower degree of data concurrency. In contrast, the higher lock granularity uses fewer system resources (such as shared memory).

The best way to determine which lock granularity level to select is for the user to evaluate they're needs in these areas.