Câu 24: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014
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…
Nội dung câu hỏi
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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. SQLServer:SSIS Pipeline 10.0: Buffers in use
- B. SQLServer: SSIS Pipeline 10.0:Private buffer memory — đáp án hiện tại
- C. Memory\Pages/sec
- D. SQLServer:SSIS Pipeline 10.0: Flat butter memory
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.