Microsoft
70-457 · Question #173
70-457 Question #173: Real Exam Question with Answer & Explanation
Sign in or unlock 70-457 to reveal the answer and full explanation for question #173. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?
Options
- Ause SQL Profiler to trace all queries that are processing on the server.
- BUse sp_configure to set a value for blocked process threshold.
- CRun the sp_who command from a query window.
- DRun the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.