Idea ID: 2690869

Apply a "with(nolock)" to SM's query

Status : Waiting for Votes
Waiting for Votes
See status update history
over 1 year ago

Hi 

 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.

thanks

qiang

Tags: