DRAG DROP
You administer a Microsoft SQL Server 2012 database.
Your database is experiencing deadlock issues.
You need to be able to monitor deadlocks.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Which three actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2012 database.
Your database is experiencing deadlock issues.
You need to be able to monitor deadlocks.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
why not:
first dbcc tracon(1222,-1)
go to configuration mgr
change startup parameters
do *NOT* restart.
then it’s enabled without downtime? After a restart, the startup parameter is used, so a dbcc traceon is not longer needed.
The answer to this question is correct, please visit this link for more information: https://www.mssqltips.com/sqlservertip/2130/finding-sql-server-deadlocks-using-trace-flag-1222/
wim,
It’s a trap!!
Look at the choices:
dbcc traceon(1221, -1)
and
Trace Flag – T1222
Notice, that traceon is 1221.
There is no trace flag for 1221:
https://msdn.microsoft.com/en-us/library/ms188396.aspx