Unanswered: How to solve or minimize locking in this case?
If batch processing and normal transactions need to run in parallel, how can I solve or minimize locking issue? Since batch processing will use PAG or TAB most of the time, how can other users to access data at that time?
From another perspective, if there are many, many transactions going on, contributing to excess round trips and network traffic, consider batching them together so that there are fewer round trips between the client and SQL Server. Consider using a lower transaction level, if appropriate.
Always manage your transaction by beginning and ending your transaction explicitly. Do not use implicit transactions.