SQL Server Performance

Low performance during data inserts

Discussion in 'Performance Tuning for DBAs' started by haridba, Oct 11, 2007.

  1. haridba New Member

    Hi all
    we are doing a data migration task which involves selecting the data from table and inserting it into other tables(which already have some records)
    inserting the data into new tables is taking so many hours it is taking 10 secons to insert a single record,
    Is there a way i can improve the performance of DML operations on this scenario?
    Thanks
    haridba, Oct 11, 2007
    #2

  2. MichaelB Member

    sometimes its easier to drop the indexes, do the insert then create the indexes again. May try a normal old BCP. It is still the fastest way to go:)
    MichaelB, Oct 11, 2007
    #3

  3. ranjitjain New Member

    You can even go for inserting rows in small batches instead of inserting them all in one go.
    ranjitjain, Oct 12, 2007
    #4

  4. satya Moderator

    Try what Mike suggested with BCP if these are straight forward inserts and also ensure to perform reindex on the tables that are involved, that updates the data pages too.
    satya, Oct 12, 2007
    #5

Share This Page