Join David M. Franklyn for an in-depth discussion in this video Configuring, monitoring, and troubleshooting data replication, part of Microsoft System Center Configuration Manager Essential Training.
- [Instructor] Okay, in this demonstration, we're going to go ahead and configure, monitor, and troubleshoot some data replication issues. So this starts by us going to the central CFG1 site, and from there, we can bring up the, as we already have, Configuration Manager Console, go to the administration workspace, and now go to Hierarchy Configuration, and we're going to select File Replication first. So in here, we're going to click on the Davemct.com Central Administration Site, to the North American Primary site, and let's go to the Properties thereof, and as you can see here in the general tab, there's a lot of information we can't change, because it's a specific link for specific file replication between the sites, because we have two separate primary sites and one central site, we need to have two links for those.
So in this case we're not going to make any changes here. We'll go to the schedule site and now we can make changes to the schedule. So the schedule availability for a selected time period we have right here because this is selected, Sunday from zero to one, but notice how we can pull that across the entire 24/7 period of a particular week. We're not going to change that. We're just going to select the Sunday at this point and now go to the rate limits and in the rate limits we're going to change these just to show it can be done.
So we're going to select the limited to specific maximum transfer rate by hour. Now why would you do this? Well in some cases they may be at certain times during the day or the week where you have to do particularly large transfers of data and you don't want this typical replication of files between the various sites to take up an excessive amount of the bandwidth given what you're already doing. So in this case we're going to limit it. We'll select let's say, four hours, zero to four, and then set the bandwidth limitation at 50%.
And then say okay to that. And now let's look at some database replication and configuring that. So in this case now we want to go to the database replication between the central administration site and our child site, ES1 for the East. And we're going to go to the properties of that. First we want to go and notice the ribbon above, we have Link Properties, Parent Database Properties, and Child Database Properties. So at first we want to select the Child Database Properties and in the database tab we have different settings here about the database.
So here you see the SQL service, the SQL Server Service Broker port, 4022 is set by default. You can turn on, and by default it is turned on, database compression, and we can set a data retention period here of five days for the global data, and then we'll just click OK on this and now we want to go and right click the CAS Central administration to ES1 Primary site, and really what we're looking for is the link properties here.
So we can right click and go to Link Properties or we could click on the Link Properties up in the ribbon. But just several different ways of doing it. And in the CAS to ES1 Replication Link Properties, we see the General tab that has the ability to enable the following types of site data for distributed views. Now remember we said distributed views are not turned on by default. So here we can turn them on or not.
We're actually not going to do this. We have the summarization interval, how long this would take, and it's 15 minutes, we can alter that as well, but we really don't want to do that. We then have the schedule tab and in the schedule tab we can again change the schedule beyond what we have, 24/7 for the whole week, and then alert, so we can generate alerts for different things which is set to do and we're really not going to make any changes here. So we're going to say OK to it.
And finally we have the sender properties that we'll configure. So in this case we're going to go to our Site Configuration and Sites node, and let me get to that, and now we're going to select the ES1 Primary site, and it already is, and in this case now we're going to go to the Settings up here in the ribbon and Configure Site Components. And that's a drop down so we have several things in it and we're going to select the software distribution and in software distribution, in the general page we're going to set the maximum number of packages to five and the maximum threads per package to eight, and then the delay before retrying and we want to set that to five minutes, and in the software distribution components property for this we'll just say OK, and now let's go ahead and check out our monitoring.
So in this case, to monitor this type of traffic we go to Monitoring workspace and note we have a Database Replication node, we'll select that. And then we're going to select the CAS to ES1 link and we want to make sure it's active and it shows as active. So now that the link is active let's simulate a issue with it by stopping the link, and in that case we're going to go over to the East-CF3 computer and now here on the East-CF3 computer we just want to go into Administrative Tools and go into the services consol, so we can get to that by scrolling down to Windows Administrative Tools in the start menu.
And we're going to Services and in Services we're looking for the SMS Executive Service that runs basically all of configuration manager. And there it is. And we're going to stop the service. And then we're going to troubleshoot the replication issue that we have and I'm sure you can appreciate that if the SMS Executive Service is not working on a configuration manager server then we're probably not going to replicate very well.
But we're going back now to the central CFG computer. And in the central CFG computer we need to go to the CM trace tool which is used to open up log files. Usually you would have done this long before. So the next few steps I'm going to do is just something that you would do if you had never opened up and used CM Trace before. So let me go and find it and we can find it in the C drive, Program Files, Microsoft Configuration Manager and then Tools.
And here is CM Trace. I'll just double click that and now make it the default program to view log files and forever more it will be. And let's just put this aside for now and now go back to our central administration site consol here and expand this and now we're going to our alerts node within the monitoring workspace and expand that and we want to go to All Alerts and see if we have anything.
Right now we have nothing, we're waiting for that stopping of the SMS executive service to show itself here. But let's see, the replication link between parent sites and looking for the replication link between the parent site and ES1. Very good, there it is. And it shows it's never triggered but it is a critical error. So we're going to go ahead and configure it and we're going to set if it's down more than three minutes to make this very quick and then say OK to that.
So we're going to the database replication area and we're looking to see if the status of the link is link failed or link degraded. We can refresh. Okay, I'm not seeing it here. Sometimes as we talked about before we have to actually turn off the configuration manager consol and bring it up again. So we're going to go ahead and try that. Ah, so there we go, that was it. Turning off the consol and starting it again is sometimes the only way to refresh. So now we see that the link state is degraded.
And we're going to go to this, right click it, and say Save Diagnostic Files from this point. And that's one reason to have CCM Trace as a log reader program to go in and see what's in those files. We're going to say save that and name it ReplicationDiagnostics. And we'll just save that for now in the root of C. And now we will go down to File Explorer and go to the root of C and then we see the replication diagnostics file and we're going to open that up in Notepad.
Alright, so in Notepad we're looking for any status that shows link failed or link degraded. And here it is right here. So that tells us that's just the diagnostic file to tell you what happened. And now we'll resolve the issue and verify the replication is functioning correctly. So, on again, the central CFG site, we're going to go back to the configuration manager consol and in the configuration manager consol we want to right click the link again that has failed or degraded and bring up the Replication Link Analyzer tool.
Okay, and you can see right away it found the problem. It found that the SMS Executive Service was not running. And this is on the E-CFG3 computer. So we can click to restart the SMS Executive Service and we'll do that. And once it's successful we can click continue and now it comes out with a report and tells us what happened. We can view the log and when we do so the log will open up in CM Trace. And as you can see the earlier issue that we were having has now been fixed.
So generally speaking, this log will show things from the very bottom thing in a log will be the latest thing that happened. And one great benefit about the Configuration Manager Trace Log Tool that you probably already know about, is it will continue to refresh the log. Not like Notepad where you have to open it and then to see any new events, close it and reopen the same file. So we're going to close this and close the issue and now we're going to refresh the consol.
And once again we get these issues where the link degraded is sticking in there just as the link active was sticking in there. Let's close the consol and open it up again. And go back to where we were which was Database Replication and look, now the link is active. And that's pretty much it. That concludes this particular demonstration.
- Planning and deploying a standalone primary site
- Ensuring domain and site server prerequisites
- Planning and expanding a standalone primary site
- Planning and deploying a multiple-site hierarchy
- Planning resource discovery and client deployment
- Managing content and replicating data in Configuration Manager
- Configuring Internet and cloud-based client management
- Advanced monitoring
- Upgrading to Configuration Manager current branch