YOU ARE A DBA OF AN ORGANIZATION WHERE SEVERAL REPLICATIONS ARE CO...

16. You are a DBA of an organization where several replications are configured.

In this configuration you have noticed that some agents suddenly stopped;

you are not aware of the reason or when the agent was down. What is the

monitoring tool you can use to find that information?

A. Replication Monitor

B. DMVs

C. Performance Monitor

D. Profiler

Answer C is correct. In Performance Monitor there is a counter object named

Replication Agent. From this you can measure the number of agents that are

running. Also, in Performance Monitor, you can monitor the Memory, CPU,

and IO counters as well. Therefore, you can combine all the necessary counters

and find the reason and time.