If NOLOCK is set, disable locks at the inner level (lock procedures themselves become no-ops).
Enable NOLOCK by default since the locks are very slow (possibly implemented with errors).