Performance Enhancements

The next step to improve your package development skills is to consider the proper use of resources. Many scenarios occur in development, staging, and production environments that can affect how packages run. For example, your server may be running other processes in parallel that are affected when an Integration Services package starts execution and puts heavy demands on server resources; or your package may use sorts and aggregations that require lots of memory that may not be available to you because other services such as SQL Server or the tables required by an Integration Services package may be locked by SQL Server to serve queries from other users.

In this section, you will learn skills to design your package ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.