Valid 70-463 Dumps shared by ExamDiscuss.com for Helping Passing 70-463 Exam! ExamDiscuss.com now offer the newest 70-463 exam dumps, the ExamDiscuss.com 70-463 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-463 dumps with Test Engine here:
You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight CPUs, 8 GB of RAM, RAID-10 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?
Correct Answer: B
Explanation/Reference: Explanation: Private buffer performance counters Instead of being created by an SSIS instance, private buffers are created by particular transformation process themselves. Their purpose is to support and optimize the performance of temporary tasks in Pipeline, like the Aggregation transformation, Sort transformation etc. Private buffer memory: this performance counter shows the full amount of physical or virtual memory used by all of the current private buffers within the Data Flow engine task in the monitoring cycle. During a data transformation, if the Data flow engine creates a buffer to support itself (not the transformation), that buffer is not considered as private. References: https://www.sqlshack.com/ssis-pipeline-performance-counters-guide/