Idea ID 2690869
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.