You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.
You need to recommend a solution to monitor the transactions that a
re running currently against SQLProd.
The solution must minimize the amount of custom code required.
What should you recommend?
A. Statistics
B. A dynamic management view
C. A trigger
D. User-defined views
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.