Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    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?

    Thank you for any suggestion.

  2. #2
    Join Date
    Aug 2002
    1,578 for information.The shorter transactions are, the shorter that locks have to be held, which results in both greater performance and scalability. Do not use a transaction to view and browse data.

    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.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts