The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P90: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Managing Replication Chapter 9 427 6. Select the Warnings tab see Figure . Figure Replication Monitor Warnings 7. Click the Configure Alerts. button and you will see the screen in Figure . Figure Configure Replication Alerts 428 Chapter 9 Managing Replication 8. Select the alert you want to configure and click the Configure button. 9. You will be taken to the Alert configuration windows. 10. In the General page you can configure the Error Message and enable the alert. 11. In the Response tab you can configure the operation who should receive this alert and the means of the notification whether it is an email pager or net-sent message. Performance Monitor Most DBAs are using Performance Monitor perfmon as a monitoring tool. Perfmon is a not only a SQL Server but also a Windows monitoring tool that has counter objects to monitor various SQL Server counters. The important thing about the Performance Monitor is that you have the option of using integrating with Profiler. There are five performance counter objects to monitor SQL Server replication using perfmon Replication Agents Replication Distribution Replication Log Read Replication Merge and Replication Snapshot. Replication Agents There is only one counter in this counter object Running. Running can be used to measure the number of replication agents currently running. You can select the specific agent as shown in Figure . Figure Replication Agent Counter Object Managing Replication Chapter 9 429 You can see from the image in Figure that you have the option of selecting the following replication agents Distribution Logreader Merge Queuereader and Snapshot. This counter is important when you want to measure whether all the replication agents are running. Replication Distribution This counter object provides information about the data delivery between distribution and subscriber Figure . Figure Replication Distribution Counter Object Performance object SQLServer Replication
