Reduce Lock granularity for transaction operations

Transaction manager uses a common lock for all operations. This reduces the concurrency of the operations since only one transaction can get a lock at any given time.