Biztalk documentation says “when there is Sql lock contention better to add extra message box”. How do we determine if the db is lock contention bound? any tips please?
use the performance monitor on the database server. add sql related performance counters found under the category SqlServer:Locks (lock timeouts/sec, lock waits/sec). i suggest you first understand how to interpret these counters.