1 person found this helpful
The isolation level(It's related to database) setting controls the default transaction locking behavior for all statements issued by a connection.
More on same in below product document link under section "Table 7-4 Connection Pool Properties in the General Tab: Common Properties"
Yes incorrect setting can cause performance issues, found below note which discusses on Isolation Level w.r.t. SQL Server