TAILIEUCHUNG - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P90

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

TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.