Chapter 20

Integration Services Administration and Performance Tuning

WHAT’S IN THIS CHAPTER

  • Overview of SSIS
  • Deploy and Configure SSIS Packages
  • Secure and Administer SSIS
  • Common Pitfalls with SSIS Performance

In keeping with the theme of focusing on how SQL Server 2012 changes the role of the DBA, in this chapter you learn how you can be better equipped as a DBA to maintain SQL Server’s Business Intelligence components. The SQL Server 2012 Business Intelligence stack includes Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

This chapter looks at the many and varied administrative tasks required for managing Integration Services. First, an overview of the Integration Services service is provided so that you will have a better understanding of the moveable parts that require the attention of an administrator. After becoming comfortable with the architecture of Integration Services, you can focus on the administration of Integration Services, including configuration, event logs, and monitoring activity. Next, you gain an understanding of the various administrative tasks required of Integration Services packages, the functional component within SSIS, including creation, management, execution, and deployment. Last, you learn how to secure all the Integration Services components.

image

For more in-depth information about Integration Services, see Professional ...

Get Professional Microsoft SQL Server 2012 Administration now with O’Reilly online learning.

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