Microsoft
70-459 · Question #122
You deploy a SQL Server instance named SQLProd that uses SQL Server 2014. You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must…
The correct answer is B. A dynamic management view. Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Transactions can be monitored.
Administer SQL Server
Question
You deploy a SQL Server instance named SQLProd that uses SQL Server 2014. You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must minimize the amount of custom code required. What should you recommend?
Options
- AStatistics
- BA dynamic management view
- CA trigger
- DUser-defined views
How the community answered
(40 responses)- A3% (1)
- B78% (31)
- C5% (2)
- D15% (6)
Explanation
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Transactions can be monitored.
Topics
#DMVs#transaction monitoring#sys.dm_exec_requests#performance monitoring
Community Discussion
No community discussion yet for this question.