when the runtime of select query over 30s, I run update query or insert query in the runtime of select query.
we got DB block issue in the update query session.
I want to apply a option in SM. DB don't be lock when run select query.
I think the following 2 methods can achieve it.
1）apply a "with(nolock)" to SM's query
2）change the "Transaction Isolation Level" to "ReadUncommitted"
Please consider to add the option.