Lesson Review in Visual Studio .NET

Printing PDF-417 2d barcode in Visual Studio .NET Lesson Review

The following questions are intended to reinforce key information presented in this lesson. The questions are also available on the companion CD if you prefer to review them in electronic form.

19

Answers to these questions and explanations of why each answer choice is right or wrong are located in the Answers section at the end of the book.

1. What types of conflict resolvers does SQL Server support (Choose all that apply.) A. .NET Framework business object components B. COM-based resolvers C. UDF-based resolvers D. Trigger-based resolvers 2. At what level is conflict resolution configured A. Publisher level B. Database level C. Subscription level D. Article level

Monitoring is an important part of a DBA s job. And because replication is a distributed activity involving multiple computers, you need to take special care in monitoring replication processes. In SQL Server 2005, the main tool for monitoring replication is the SSRM, although you can also monitor parts of the replication configuration via SSMS. You can also use Transact-SQL and RMO to monitor replication. In addition, you can set up alerts for replication agent events and use System Monitor to monitor replication processes. This lesson focuses on setting up SSRM to monitor replication processes, setting up alerts for replication agent events, and using System Monitor s replication counters and objects.

After this lesson, you will be able to:

Use SSRM to manage replication. Configure replication alerts. Use Performance Monitor to monitor replication.

SSRM is the new graphical tool that SQL Server 2005 provides to help you monitor replication agents and the replication process. Although you can use SSMS to monitor parts of the replication process or use Transact-SQL or RMO, SSRM is the most important tool for monitoring replication, presenting a Publisher-focused view of all replication activity. You can start SSRM by right-clicking the replication folder in SSMS and choosing Launch Replication Monitor. Figure 19-17 shows the SSRM. Alternatively, you can run SSRM from its default path: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlmonitor.exe.

Figure 19-17

19

By default, only members of the sysadmin fixed server role can monitor replication, but a system administrator can give non-sysadmin users permission to monitor replication by assigning them to the replmonitor role. The replmonitor role is a fixed database role in the distribution database. Here is how to grant users permission to monitor replication processes: 1. Open SSMS and connect to the Distributor server. 2. Navigate to the Security, Logins folder. 3. Right-click the login of the user you want to be able to monitor replication and choose Properties. 4. Select the User Mapping page. 5. Select the distribution database in the Users Mapped To This Login Table grid. 6. Select the Map check box for the distribution database. 7. In the Database Role Membership For: Distribution section, select the replmonitor check box, as Figure 19-18 shows. Click OK.

Being a member of the replmonitor database role does not grant the user any other administration rights besides monitoring. Members of this role can monitor replication, but unless additional rights are granted, they cannot change the configuration.

How would you grant a user permission to monitor replication In the Distributor server, make the user a member of the replmonitor role in the distribution database.

SSRM lets DBAs monitor replication from a central administration point. Here is how to use SSRM to monitor a Publisher: 1. Open SSRM. 2. In the console tree, select Replication Monitor. 3. Click the Add Publisher hyperlink. 4. In the Add Publisher dialog box, from the Add drop-down list, select Add SQL Server Publisher. 5. Provide the authentication parameters and click Connect. You can also add all Publishers that use the same Distributor by selecting Specify A Distributor And Add Its Publishers from the Add drop-down list. After you add the distributor, you can navigate to the server and all its publications. SSRM helps you monitor the replication status and history of replication agents. And if you have the appropriate rights, you can change the configuration of publications and subscriptions. To add new publications or subscriptions, however, use SSMS. To review the history of the Snapshot Agent, for example, take the following steps: 1. Open SSRM. 2. Expand Replication Monitor, My Publishers, Publisher Name. 3. Select the publication you want.