Add a Log for Data Flow Performance Counters
This procedure describes how to add a log for the performance counters that the data flow engine provides.
If you install Integration Services on a computer that is running Windows Server 2003, and then upgrade that computer to Windows Server 2008, the upgrade process removes the Integration Services performance counters from the computer. To restore the Integration Services performance counters on the computer, run SQL Server Setup in repair mode.
To add logging of performance counters
In Control Panel, if you are using Classic view, click Administrative Tools. If you are using Category view, click Performance and Maintenance and then click Administrative Tools.
In the Performance dialog box, expand Performance Logs and Alerts, right-click Counter Logs, and then click New Log Settings. Type the name of the log. For example, type MyLog.
In the MyLog dialog box, click Add Counters.
Click Use local computer counters to log performance counters on the local computer, or click Select counters from computer and then select a computer from the list to log performance counters on the specified computer.
In the Add Counters dialog box, select SQL Server:SSIS Pipeline in the Performance object list.
To select performance counters, do one of the following:
Select All Counters to log all performance counters.
Select Select counters in list and select the performance counters to use.
In the MyLog dialog box, review the list of logging performance counters in the Counters list.
To add additional counters, repeat steps 5 through 10.
You must start the Performance Logs and Alerts service using a local account or a domain account that is a member of the Administrators group.