SSIS Performance Tuning Tips

Описание к видео SSIS Performance Tuning Tips

video talks about
SSIS Performance Tuning Tips
SSIS Performance Tuning Tips and Tricks
SSIS Performance Tuning Techniques
Performance Tuning Tips
Performance Tuning in ssis


a. When loading huge data , Transactions load
1. drop all non clustered indexes and Clustered Indexes
2. Load the data
3. Create all the Indexes

Master data -- not more than 1000

b. Select Only Required Columns

c. Avoid Asynchronous transformations

d. Try to reduce Blocking/Semi blocking transformations.

Step by step SSIS Training videos
SSIS Tutorial

more videos at
   / @training2sqlmsbi  

Комментарии

Информация по комментариям в разработке