Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Record locking during the porting of data

Discussion in 'General' started by Pradeep Mathew, Jun 12, 2013.

  1. Pradeep Mathew

    Pradeep Mathew New Member

    When I am extracting the data from one or more tables in a database and updating the consolidated value to other database, the source database transactions are getting hang. Is it advisable to make view file for the source database and whether it will affect any performance.

    Regards

    Pradeep
  2. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    If it would be acceptable to retreieve data that has not yet been committed, you might see a performance benefit from using a NOLOCK index hint.

    Another option could be to better optimize the indexes on your source database/tables, or taking a snapshot or backup of the database for loading.

Share This Page

Sponsored link: