Replication Status Column Set

This is a more expanded column set that is useful when drilling down into issues with backlogs. It shows more context about what the cause of a backlog might be. New information in this column set includes:

InConnections

Shows the number of inbound connections for this member in this replica set. This is helpful for identifying which computers are hubs in the replication topology.

InJoinedConnections and OutJoinedConnections

This shows how many of the Inbound/Outbound connections are currently joined (and hence able to replicate).

LastInJoinInterval

Time interval since the last of this member’s inbound partners joined to replicate.

LastOutJoinInterval

Time interval since the last of this member’s outbound partners joined to replicate.

LocalChangeOrdersCycle

Shows changes initiated by this member in the last 24 hours. Regularly look to see that changes are being initiated from computers you expect. Look for unusual cases of many members suddenly originating changes, or for one computer unexpectedly initiating a lot of change.

StagingFilesRegeneratedCycle

On Windows 2000 SP3 and later, this shows that the staging directory was too small and that files are being purged from this cache. If this condition occurs frequently:

To increase the size of the staging directory

  1. In the Run dialog box, type regedit.exe, and click OK.
  2. Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\NtFrs\Parameters.
  3. Right-click the Staging Space Limit in KB entry and click Modify.
  4. Click Decimal, type the desired size of the staging directory in kilobytes, and click OK.
  5. Close the registry editor.
  6. At the command prompt, type net stop ntfrs & net start ntfrs.