Tuesday, June 8, 2010

Bulk Import

Points to remember when Bulk-Loading Data

We use different Import mechanisms (BCP , Bulk Insert or SSIS) to bulk-load data , we should consider the following factors to get top performance

1.Disable indexes and Bulk-load data
The best scenario is bulk- loading data into an empty heap ( a table with no indexes )

Disable indexes before Bulk-load and rebuild indexes once the Bulk-Load completed.

2.Bulk-logged Recovery Model
Change recovery mode from FULL to Bulk-Logged lets database perform minimal logging during the data load.

Data that is loaded during a bulk load usually has no need for the point-in-time recovery capability of the full recovery model.

Decreasing the volume of log writes improves performance.

Note: Recovery models - Full [Default Recovery Model] ,
Bulk Logged and
Simple

No comments:

Post a Comment