What should you create?

Correct Answer for the following Question is given below

You have a database that is accessed by 300 concurrent users.You need to log all of the queries that become deadlocked. The solution must meet the following requirements:Provide a representation of the deadlock in XML format.Minimize the impact on the server.What should you create?Analyze Deadlocks with SQL Server ProfilerUse SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server. Using SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis.To trace deadlock events, add the Deadlock graph event class to a trace. This event class populates the TextData data column in the trace with XML data about the process and objects that are involved in the deadlock. SQL Server Profiler can extract the XML document to a deadlock XML (.xdl) file which you can view later in SQL Server Management Studio.


What should you create?


A SQL Server Profiler trace

A script that enables trace flags

A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic management views

A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic management views

Correct Answer

The Correct Answer for this Question is

A SQL Server Profiler trace


The Question – What should you create? has been answered correctly and answers for the question is A SQL Server Profiler trace

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment