Explanation:SQL Server Integration Services is designed to process large amounts of data row by row in memory with high speed. Because of this, it is important to understand resource utilization, i.e., the CPU, memory, I/O, and network utilization of your packages. 4. If SSIS is not able to drive close to 100% CPU load, this may be indicative of:
A. Software Contention
B. Application contention
C. Processor contention
D. None of the mentioned
Answer:A
Explanation:SQL Server Integration Services is designed to process large amounts of data row by row in memory with high speed. Because of this, it is important to understand resource utilization, i.e., the CPU, memory, I/O, and network utilization of your packages. 4. If SSIS is not able to drive close to 100% CPU load, this may be indicative of:
A. Software Contention B. Application contention C. Processor contention D. None of the mentioned
Explanation:In Application contention, SQL Server is taking on more processor resources, making them unavailable to SSIS. 5. Point out the wrong statement :