You are a database administrator for AIOTestKing.com. Your company is a large retail store chain with more than 500 outlets. Each retail store maintains its own SQL Server 2005 database that must replicate data to the corporate server each night. You need to monitor replication for each store. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Configure warnings and alerts by using Replication Monitor.
B.
Monitor server activity by using SQL Server Profiler.
C.
Monitor replication activity by using the Activity Monitor.
D.
Monitor the current average and worst performance ratings by using Replication Monitor.
Explanation:
MicrosoftSQL ServerReplication Monitor is a graphical tool that allows you to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance of publications and subscriptions, allowing you to answer common questions, such as:– Is my replication system healthy?
– Which subscriptions are slow? – How far behind is my transactional subscription?
– How long will it take a transaction committed now to reach a Subscriber in transactional replication?
– Why is my merge subscription slow?
– Why is an agent not running?