- Home
- Products
- Integration
- Tutorial
- Barcode FAQ
- Purchase
- Company
Lesson Review in Visual Studio .NET
Lesson Review PDF-417 2d Barcode Generator In .NET Framework Using Barcode creation for VS .NET Control to generate, create PDF417 image in VS .NET applications. www.OnBarcode.comPDF 417 Recognizer In VS .NET Using Barcode reader for .NET framework Control to read, scan read, scan image in .NET framework applications. www.OnBarcode.comThe 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. Print Bar Code In Visual Studio .NET Using Barcode generation for VS .NET Control to generate, create bar code image in .NET framework applications. www.OnBarcode.comScan Bar Code In VS .NET Using Barcode scanner for VS .NET Control to read, scan read, scan image in .NET framework applications. www.OnBarcode.com 19
Generate PDF-417 2d Barcode In C#.NET Using Barcode drawer for VS .NET Control to generate, create PDF-417 2d barcode image in Visual Studio .NET applications. www.OnBarcode.comPainting PDF-417 2d Barcode In .NET Framework Using Barcode drawer for ASP.NET Control to generate, create PDF 417 image in ASP.NET applications. www.OnBarcode.comManaging Replication
Generating PDF 417 In VB.NET Using Barcode creation for Visual Studio .NET Control to generate, create PDF 417 image in VS .NET applications. www.OnBarcode.comGS1 DataBar Stacked Maker In VS .NET Using Barcode creator for .NET framework Control to generate, create GS1 DataBar Stacked image in .NET framework applications. www.OnBarcode.comNOTE
Create Barcode In VS .NET Using Barcode generator for .NET Control to generate, create bar code image in .NET applications. www.OnBarcode.comCreating Code 128 In .NET Framework Using Barcode creation for VS .NET Control to generate, create USS Code 128 image in .NET framework applications. www.OnBarcode.comAnswers
PDF417 Creator In .NET Using Barcode printer for VS .NET Control to generate, create PDF417 image in .NET framework applications. www.OnBarcode.comPlanet Creation In VS .NET Using Barcode drawer for Visual Studio .NET Control to generate, create USPS Confirm Service Barcode image in .NET framework applications. www.OnBarcode.comAnswers 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. ANSI/AIM Code 39 Encoder In Java Using Barcode creator for Android Control to generate, create Code 39 Full ASCII image in Android applications. www.OnBarcode.comDraw QR Code 2d Barcode In Objective-C Using Barcode printer for iPhone Control to generate, create Quick Response Code image in iPhone applications. www.OnBarcode.com1. 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 Barcode Decoder In VB.NET Using Barcode decoder for .NET framework Control to read, scan read, scan image in VS .NET applications. www.OnBarcode.comData Matrix 2d Barcode Drawer In None Using Barcode generation for Office Excel Control to generate, create Data Matrix ECC200 image in Microsoft Excel applications. www.OnBarcode.comLesson 5: Monitoring Replication
Draw UPC-A In Java Using Barcode drawer for BIRT reports Control to generate, create UPC-A Supplement 5 image in BIRT applications. www.OnBarcode.comEncode UPC A In Java Using Barcode creation for Java Control to generate, create Universal Product Code version A image in Java applications. www.OnBarcode.comLesson 5: Monitoring Replication
2D Barcode Creation In .NET Using Barcode maker for ASP.NET Control to generate, create Matrix Barcode image in ASP.NET applications. www.OnBarcode.comDrawing EAN / UCC - 13 In VB.NET Using Barcode printer for .NET Control to generate, create EAN13 image in VS .NET applications. www.OnBarcode.comMonitoring 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. Estimated lesson time: 30 minutes
Using SQL Server Replication Monitor
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 SQL Server Replication Monitor
19
Managing Replication
Configuring Non-sysadmin Access to Replication Monitoring
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. Figure 19-18 Granting replication monitoring rights
Lesson 5: Monitoring Replication
NOTE
Security
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. Quick Check
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. Quick Check Answer
Using SSRM to View Replication Status
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.
|
|