You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight
CPUs, 8 GB of RAM, RAID-1 storage, and a 10-gigabit Ethernet connection.
A package named Package1 runs on SQL1. Package1 contains 10 data tasks. Package1 queries 3 GB of
data from the source system.You review the performance statistics on SQL1 and discover that Package1 executes slower than
expected.
You need to identify the problem that is causing package1 to execute slowly.
Which performance monitor counter data should you review?
A.
SQLServer:SSIS Pipeline 10.0:Buffers in use
B.
Processor\\% Idle Time
C.
SQLServer:SSIS Pipeline 10.0:Buffers spooled
D.
SQLServer:SSIS Pipeline 10.0:Private buffer memory