Câu 44: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases
You administer a Microsoft SQL Server database. Users report that a billing application is throwing errors during busy times of the day. You identify that the following error is regularly written to the application's error log every day between 4:00 pm and 5:30 pm:Error 1205: Transaction (Process ID) was deadlocked on…
Nội dung câu hỏi
You administer a Microsoft SQL Server database. Users report that a billing application is throwing errors during busy times of the day. You identify that the following error is regularly written to the application's error log every day between 4:00 pm and 5:30 pm:Error 1205: Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. You need to determine the cause of deadlocks. You start a trace using SQL Server Profiler. 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. Lock: Timeout
- B. Lock: Escalation
- C. Lock: Deadlock
- D. Deadlock graph — đáp án hiện tại
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.