Add a Log for Data Flow Performance Counters
Applies To: SQL Server 2016
This procedure describes how to add a log for the performance counters that the data flow engine provides.
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.