Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    Unanswered: frequent insert & delete table in multi-processing env

    Any suggestion how to improve the performance for frequent insert & delete table in multi-processing env? e.g prevent deadlock, blocking ... etc

  2. #2
    Join Date
    Jan 2003
    Geneva, Switzerland
    Make sure that the queries run as smoothly as possible, with as little IO as possible, and with short transactions.

    So this means making sure that indexes, etc. are "correct" for your environment.
    Use showplan, statistics IO, etc to tune both the inserts/updates/deletes and any select queries.

    Depending on the system you may also want to tune the log IO size, the ULC cache, etc. sp_sysmon can give you some hints on these issues, and of course the P&T Manual...


Posting Permissions

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