If you are connected to the secondary server and you are reading data from in-memory tables, the transaction isolation level is automatically set to READ COMMITTED. The transaction level is READ COMMITTED even if you have specified it as REPEATABLE READ, or SERIALIZABLE.

Additionally, if load balancing is used, the isolation level is READ COMMITTED by default.