| |
Simple
tricks to speed up your DTS performance
Author:
Gianluca Nacci Is your extremely important Transform
Data Task slower than a turtle? Try these simple tricks to speed things up:
- Instead of defining a transformation for each field (the
default auto-mapping option for SQL Server), group as many fields as possible
into a single transformation. For example, group all CopyColumn transformations
together. Your data warehouse will be grateful!
- For instant
improvement, temporarily disable indexes and constraints by checking the "Use
Fast Load" feature in the Options tab of your Transformation Properties dialog
box.
- Don't commit everything to the end! When you are
dumping loads of data, the final commit can take a lifetime to finish. Try setting
a row limit and then commit! To do this, simply insert the batch size you
want to commit into the Options tab of your Transformation Properties dialog box
and let SQL Server do the rest!
Go
to top
| | |
|
