To Run Entire Session in specific Isolation Lev

performance
#performance#session
--add this line in the beginning of the all the commands set transaction isolation level isolationlevelname
--ex: set transaction isolation level read committed
--Isolation levels:
 --pesimistic:
 --read committed
 --read uncommitted
 --repeatable read
 --serializable
 --optimistic:
 --snapshot
 --snapshot read committed

--to use snapshot isolation level, first turn on setting called "allow snapshot isolation" @ db level settings and also add the command in the query window.
--to use snapshot read committed, turn on setting called "is read committed snapshot on" @ db level.