You create an ASP.NET application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application uses a Microsoft SQL Server database. During testing, the application intermittently logs the following exception message:
“Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.”
The error cannot be reproduced in the development environment. You need to identify the root cause of the exception. What should you do?
A.
Use Event Viewer.
B.
Use SQL Server Profiler.
C.
Use Performance Monitor.
D.
Configure the system.transactions trace source in the Web.config file.