SQL Server Gems

Thursday, June 14, 2007

Monitoring performance of SSIS Data Flow

Recently, a friend was asking me how to estimate as well as monitor the performance of the SSIS packages.

Check out
http://www.microsoft.com/technet/prodtechnol/sql/2005/
ssisperf.mspx#EKBAC


http://www.scalabilityexperts.com/default.asp?action=article&ID=167

You can monitor the performance of the data flow engine in SSIS too. http://msdn2.microsoft.com/en-us/library/ms137622(SQL.90).aspx

Very useful stuffs!

0 Comments:

Post a Comment

<< Home