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?
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.
Option B Is right
Analysis Services Dynamic Management Views (DMV) are query structures that expose information about local server operations and server health. The query structure is an interface to schema rowsets that return metadata and monitoring information about an Analysis Services instance.
Yes. B is right
B.