Using SSIS for Performance Monitoring
You can perform performance monitoring for SSIS using System Monitor; compared to SQL Server, this has relatively few performance objects. The first object is the SSIS Service counter, and it has only one counter; SSIS Package Instances, which tells you how many packages are currently executing.
The other object is SQLServer: SSIS Pipeline, and it contains a longer list of counters, listed briefly here:
Blob Bytes Read The number of blob bytes read from all data sources in total
Blob Bytes Written The number of blob bytes written to all data sources in total
Blob Files in Use The number of blob spooling files in use throughout the pipeline
Buffer Memory The amount of memory allocated to buffers in the pipeline ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.
