No-lock SQL Queries Lock _tenant and _sec-authentication-domain
When running read only select statements against multi-tenant enabled databases the session will lock _tenant records... including _tenant records that are not related to the current tenant login