What should you recommend?

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

Answer: B

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.

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments