PrepAway - Latest Free Exam Questions & Answers

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.)

PrepAway - Latest Free Exam Questions & Answers

Answer:

4 Comments on “Which three actions should you perform in sequence?

  1. Henry Figgins says:

    dbcc traceon (1221,-1) doesn’t exist. Maybe that’s why it isn’t the right answer. Otherwise, The benefit of using the -T startup option is that you can ensure the trace flag is enabled even if SQL Server gets restarted.
    https://www.mssqltips.com/sqlservertip/2130/finding-sql-server-deadlocks-using-trace-flag-1222/
    Which is so subtle, I don’t know who would be able to answer this question correctly without first seeing the question




    0



    0

Leave a Reply