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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
