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.
Bạn đang xem 16. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF