What is the recommended action you should take to start global trace flags?
You manage an instance of SQL Server 2008. You discover some deadlocks on one of the databases stored inthe instance.
You want to start the global trace flag 1204 to obtain information about locks and resourcesparticipating in these deadlocks.
What is the recommended action you should take to start global trace flags?
Which Transact-SQL statement should you run?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas 15 databases. Users report that some queries take a long time to complete. You investigate and discoverdeadlocks are causing this problem.
You want to receive information about the resources and types of locks that are causing deadlocks along with thecurrent command affected by the deadlocks.
You want to receive this information in Extensible Markup Language(XML) format.
Which Transact-SQL statement should you run?