Answers B and D are correct. Both Answers B and D provide information about locks and application blocking. Answers A and C provide only process information for those programs currently executing. System Monitor can provide only quantitative information about SQL Server lock requests and deadlock situations. For more information, see the following sources:
|