Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Why does my SSIS package run slower in BIDS than DTEXEC?

If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have likely noticed that SSIS packages run slower in BIDS as opposed to running them in a SQL Server agent job (which uses the command prompt utility DTEXEC) or when in integration services and clicking Run Package (which calls DTEXECUI which creates a command line used by DTEXEC).  My experience is that the packages in BIDS run at least 20% slower.  Why is that?

Well, BIDS is slower than other methods when running a package because of the overhead of debug mode as well as preparing the BIDS interface to trace what happens during execution.  If you run the package in BIDS, you will always be running in debug mode…there is no way around that.  But you can instead deploy and run your package with DTEXEC or DTEXECUI for a performance boost.  For more details on how to run the package with these other methods, check out How to: Run a Package.

More info:

Why does my package run slower in BIDS than DTEXEC?

Always use dtexec.exe to test performance of your dataflows. No exceptions.

For more performance tips on loading data:

We Loaded 1TB in 30 Minutes with SSIS, and So Can You

The Data Loading Performance Guide

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.