Câu 22: 70-764: Administering a SQL Database Infrastructure
You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing the issue. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
Nội dung câu hỏi
You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing the issue. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
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. Set the blocked process threshold, and then run SQL Server Profiler.
- B. Set the blocked process threshold, and then create an alert. — đáp án hiện tại
- C. Enable trace flag 1204, and then create an alert.
- D. Create a job that queries the sys.dm_os_waiting_tasks dynamic management view.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.
Chưa có bình luận. Mở giao diện tương tác để bắt đầu thảo luận.