Câu 98: 70-764: Administering a SQL Database Infrastructure
You administer a Microsoft SQL Server 2016 database. Users report that a billing application becomes unresponsive during busy times of the day. While investigating, you notice large number of processes taking or waiting for table locks. You suspect that SQL Server is assigning stronger locks to queries. You start a SQ…
Nội dung câu hỏi
You administer a Microsoft SQL Server 2016 database. Users report that a billing application becomes unresponsive during busy times of the day. While investigating, you notice large number of processes taking or waiting for table locks. You suspect that SQL Server is assigning stronger locks to queries. You start a SQL Profiler trace. Which event should you select?
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. Deadlock graph
- B. Lock: Escalation — đáp án hiện tại
- C. Lock: Timeout
- D. Lock: Deadlock
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.