{"id":12479,"date":"2012-04-20T18:02:55","date_gmt":"2012-04-20T17:02:55","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=12479"},"modified":"2012-04-20T18:02:55","modified_gmt":"2012-04-20T17:02:55","slug":"mms-2012-deep-dive-into-configmgr-2012-drs-and-sedo","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=12479","title":{"rendered":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO"},"content":{"rendered":"<p>Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK<\/p>\n<p>The session is on the new replication model: RCM, DRS, and SEDO.<\/p>\n<p><strong><u>Key Concepts<\/u><\/strong><\/p>\n<ul>\n<li>SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication<\/li>\n<li>Data Replication Service (DRS)<\/li>\n<\/ul>\n<p><strong><u>Terminology<\/u><\/strong><\/p>\n<ul>\n<li>Stored procedure: sproc<\/li>\n<li>SSB: SQL Service Broker<\/li>\n<li>Change Tracking: SQL Server Change Tracking<\/li>\n<\/ul>\n<p>More:<\/p>\n<ul>\n<li>RCM: Replication Configuration Management\/Monitoring<\/li>\n<li>Replication Pattern: a set of rules on what will replicate<\/li>\n<li>Replication group: a set of tables that are monitored and replicated together<\/li>\n<li>Replication Link: a replication connection between two SQL servers for a particular RG<\/li>\n<li>Backlog: Unable to write data t the SQL Server DB after being received in the SSB Queue (usually SQL Server write performance)<\/li>\n<\/ul>\n<p><strong><u>New Replication Model<\/u><\/strong><\/p>\n<ul>\n<li>Global data is anything an admin creates and is replicated everywhere, e.g. collection rules<\/li>\n<li>Site data is stuff like status, collection membership results, replicated up to parent site.<\/li>\n<\/ul>\n<p>Client generates XML file and copies to management point.&#160; MP copies MIF to the site server.&#160; Site server process it.&#160; DRS replicates the changed data to the parent&#160; CAS contains the discovery data.<\/p>\n<p><strong><u>SQL Server Change Tracking<\/u><\/strong><\/p>\n<ul>\n<li>Change tracking allows application to keep a record of rows in a table that have been changed: insert\/update\/deete<\/li>\n<li>Does not track changed data \u2013 obtained directly each sync<\/li>\n<li>Added in SQL Server 2008 \u2026 not to be confused with Change Data Capture<\/li>\n<li>Is enabled at the DB level and at the table level.<\/li>\n<\/ul>\n<p>DO NOT ALTER THIS SETTING ON A SITE DATABASE<\/p>\n<p><strong><u>SQL Service Broker<\/u><\/strong><\/p>\n<p>Messaging service:<\/p>\n<ul>\n<li>Asynchronous queue based service<\/li>\n<li>Guaranteed delivery (not infrastructural guarantee \u2013 developer guarantee)<\/li>\n<li>Allows messages to be grouped into a conversation \u2026 messages processed in order, allows for multiple threads to process queue<\/li>\n<\/ul>\n<p>Elasticity:<\/p>\n<ul>\n<li>Allows scalability<\/li>\n<\/ul>\n<p><strong><u>Replication Patterns<\/u><\/strong><\/p>\n<ul>\n<li>Global data flows in both directions.&#160; CAS and primaries all have the same data, e.g. collections and package meta data.<\/li>\n<li>Site data flows up.<\/li>\n<li>Global-proxy is admin and control data for secondary sites.&#160; A primary and secondary sites all have the same data.&#160; Subset of global data that secondary sites needs.&#160; Leverages SQL 2008 R2 Express at the secondary site with 10 GB limit.<\/li>\n<\/ul>\n<p>Select * from vReplicationData to find all RGs and their sync schedules<\/p>\n<p>ID is the key field in here.<\/p>\n<p><strong><u>Provider Access<\/u><\/strong><\/p>\n<p>SMS_ReplicationGroup is a new WMI class that supports replication.&#160; 1 instance per RG.&#160; Status propert allow you to determine the sttus of the RG.<\/p>\n<p>What\u2019s in an RG?<\/p>\n<p>Select * from vArticleData where ReplicationID = XX&#160; \u2026. using ID from above query<\/p>\n<p>How big is the RG?<\/p>\n<p>EXEC spDiagGetSpaceUsed<\/p>\n<p>If a site goes down for a week or two, how much data must you send across?&#160; Use the above query to figure out how much data must be replicated by the RG.<\/p>\n<p><strong><u>Demo<\/u><\/strong><\/p>\n<p>In the SQL Management Studio.&#160; Select * from vReplicationData. Can see all the patterns for global, site and global-proxy.&#160; SyncInterval is the number of minutes between replications.&#160; DRS runs every 5 minutes .. no control over that.&#160; <\/p>\n<p>Select * from vArticleData where ReplictionID = 7.&#160; Looks like Endpoint Protection data being replicated here.<\/p>\n<p>Runs spDiagGetSpaceUsed .. takes a while.&#160; Returns the size of the tables.&#160; Replication Pattern shows the amount of data to replicate if you lose a site for the 3 patterns (global, site, global_proxy).<\/p>\n<p><strong><u>DRS Architecture<\/u><\/strong><\/p>\n<ul>\n<li>RCM handles replication link setup, maintenance and monitoring \u2013 command and control.&#160; It\u2019s a thread of SMSEXEC.<\/li>\n<li>SSB is the transmission engine of replication<\/li>\n<li>The Sender still lives and is used for bulk copy for initialization and re-init.<\/li>\n<li>5 day limit on DRS for outages &#8211; Due to the need to retain changes.&#160; It retains 5 days of data.&#160; Try to expand this for a 30 day outage and ConfigMgr needs to maintain 30 days of data.&#160; It\u2019s 5 days to handle a long weekend apparently \u2013 site breaks at start of holiday, come back 4 days later and fix it.&#160; <\/li>\n<\/ul>\n<p><strong><u>Initialisation:<\/u><\/strong><\/p>\n<ol>\n<li>BCP: to extract table data<\/li>\n<li>Sender: SMS EXEC sender thread<\/li>\n<li>SMB\/CIFS: copy data to the destination<\/li>\n<\/ol>\n<p><strong><u>On-going replication<\/u><\/strong><\/p>\n<ol>\n<li>SQL Server Change Tracking <\/li>\n<li>DRS sprocs and SQLCLR<\/li>\n<li>SQL Server Service Broker<\/li>\n<li>XML<\/li>\n<\/ol>\n<p><strong><u>Demo \u2013 Break replication<\/u><\/strong><\/p>\n<p>SQL DBA has a bad day and disables dbo.ConfMgrDRSQueue.&#160; CMTrace is started from DVD.&#160; Opens rcmctrl log on site server.&#160; See that the queue not running causes and error.&#160; We can see that ConfigMgr actually reached out into SQL and re-enabled the queue.&#160; <\/p>\n<p>In CMconsole , we have send demo.&#160; The link is degraded in one direction but not the other under Database Replication.&#160; Looks like TCP 1433 connectivity issue.<\/p>\n<p><strong><u>Site Initialisation<\/u><\/strong><\/p>\n<ol>\n<li>Setup start<\/li>\n<li>Setup asks CAS for site number.&#160; If you have more than 50,000 clients, then you need SQL Enterprise Edition to chunk up data in the DB and partition it.<\/li>\n<li>Setup finished and waits for replication to initialise.<\/li>\n<li>The replication configuration data is requested.&#160; This group tells RCM as the primary how replication should be setup<\/li>\n<li>CSA receives request and BCPS out the data and sends it via sender back to the primary<\/li>\n<li>Primary now request remaining Global Replication Groups.&#160; CAS creates the BC packages and send them back to the primary.&#160; Primary then applies the new data from the CAS.<\/li>\n<li>Primary site receives BCP fles and inserts all the data from the CAS&gt;&#160; The primary can now switch to normal replication.<\/li>\n<\/ol>\n<p><u><strong>DRS Message Replication<\/strong><\/u><\/p>\n<ul>\n<li>Provider executes query that modifies table<\/li>\n<li>SQL Server writes entries into change tracking table<\/li>\n<li>On DRS sync: changes are packages up and inserted into SQL Server message queue sing a stored proc.<\/li>\n<li>Message Broker transmits the message to the receiving site.<\/li>\n<li>RCM monitors the queue launching activation stored procs to process<\/li>\n<li>And more on receiving side to insert modifications on receiving side<\/li>\n<\/ul>\n<p><strong><u>WARNING: When A CAS Goes Offline<\/u><\/strong><\/p>\n<p>When the CAS goes offline for more than 5 days, don\u2019t make changes on the Primary as a substitute as the CAS.&#160; The CAS will re-initialise the primaries after more than 5 days outage, thus wiping the Primary\u2019s changes.<\/p>\n<p><strong><u>DRS Troubleshooting<\/u><\/strong><\/p>\n<ul>\n<li>The Replication Link Analyser RLS should be yur first stop.&#160; It\u2019s predictable and can do some fairly complex remediation<\/li>\n<li>RCM Log should be the follow up.&#160; But this is just a summary of what has happend.<\/li>\n<li>For transmissions layer errors, the SSB queue is sometimes the most immediate source for error messages (of this type)<\/li>\n<\/ul>\n<p><u><strong>Views for Detailed Info<\/strong><\/u><\/p>\n<ul>\n<li>The main logging view: vLogs.&#160; They log into the DB.&#160; Select top 1000 * from vLogs order by LogTime desc.&#160; Limit that number.&#160; DO not select everything.&#160; Will hammer prod environment and compund the issue.<\/li>\n<li>SMS_Replication_Configuration_Monitor registry key to configure logging<\/li>\n<\/ul>\n<p><strong><u>DRS Troubleshooting<\/u><\/strong><\/p>\n<ul>\n<li>Ensure that TCP 1433 exception is there for SQL Service and 4022 for SQL Broker.<\/li>\n<li>SSB keys transmitted through setup \u2013 monitoring with Hman.<\/li>\n<li>spDiagDRS will give you an overview of the state of DRS replication at the site.&#160; SiteStatus (coded), Replication Group Initialization Status, DRSQueueStates, QueueLenghts (ideally 0 and 0 or you have a backlog), Replication Group Status deltails the last time messages sent<\/li>\n<\/ul>\n<p><strong><u>Demo: View Queues<\/u><\/strong><\/p>\n<p>Click on the queues in SQL under service broker under CM database.<\/p>\n<p><strong><u>Procedural troubleshooting of DRS DEMO<\/u><\/strong><\/p>\n<p>Turns of SQL Broker. Makes a change to Client Policy.<\/p>\n<ol>\n<li>Run spDiagDRS: EXEC spDiagDRS in SQL MS.&#160; We see messages jammed in the outbound queue.<\/li>\n<li>SSB transmission_queue:&#160; <\/li>\n<li>Service broker queues: We see connection failed errors.&#160; Telnet to the port and we see it fails.<\/li>\n<li>vLogs: select * from vLogs ORDER BY LogTime DESC (beware * in real world \u2026 too much data)<\/li>\n<li>RCM_ReplicationLinkStatus<\/li>\n<\/ol>\n<p>The Database Replication link in CM console will flip to degraded and then flip to fail after about 25 minutes.&#160; Can run Replication Link Analyzer (RLA).&#160; In the demo it shows that there\u2019s a network connectivity issue.<\/p>\n<p>Invoke-WmiMethod \u2013namespace rootrootsmssite_CAS \u2013path SMS_ReplicatinGroup \u2013Name InitializeData = arguementlist \u201c20\u201d, \u201cCAS\u201d, \u201cPR1\u201d to reinitialize a RG.&#160; RLA should do this for you if required.<\/p>\n<p><strong><u>SEDO \u2013 Why do we need a way of controlling changes?<\/u><\/strong><\/p>\n<ul>\n<li>As global data is replicated everywhere, a user on a primary site culd change an object at the same time as a user on the CAS or another primary.<\/li>\n<li>This is an unavoidable consequence of multi-master replicated data model \u2013 ask AD.<\/li>\n<li>SEDO is the solution to this.<\/li>\n<\/ul>\n<p><strong><u>What is SEDO?<\/u><\/strong><\/p>\n<ul>\n<li>SEDO = Serialized Editing of Data\/Distributed Objects<\/li>\n<li>Provides a way to enforece a single user editing of an object at any one time.<\/li>\n<li>A lock request round trip can take less than 200ms from Primary to CAS to Primary<\/li>\n<li>Default Timeout is 5 minutes.<\/li>\n<li>Only SEDO enabled objects require users to get a lock<\/li>\n<li>Supports explicit and implicit lock handling.<\/li>\n<li>This is all transparent to admins.&#160; Important for devs building extensions to CM.<\/li>\n<\/ul>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:865e5056-d3ff-4707-b4a6-c08867fd77e1\" class=\"wlWriterEditableSmartContent\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/Event+Notes\" rel=\"tag\">Event Notes<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Events\" rel=\"tag\">Events<\/a>,<a href=\"http:\/\/technorati.com\/tags\/System+Center\" rel=\"tag\">System Center<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Configuration+Manager\" rel=\"tag\">Configuration Manager<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=12479\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[14],"tags":[60,176,177,193],"class_list":["post-12479","post","type-post","status-publish","format-standard","hentry","category-eventnotes","tag-configuration-manager","tag-eventnotes","tag-events","tag-system-center"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"AFinn\"\/>\n\t<meta name=\"google-site-verification\" content=\"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aidanfinn.com\/?p=12479\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro\" \/>\n\t\t<meta property=\"og:description\" content=\"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aidanfinn.com\/?p=12479\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-04-20T17:02:55+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2012-04-20T17:02:55+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@joe_elway\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@joe_elway\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#article\",\"name\":\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro\",\"headline\":\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO\",\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"},\"datePublished\":\"2012-04-20T18:02:55+01:00\",\"dateModified\":\"2012-04-20T18:02:55+01:00\",\"inLanguage\":\"en-GB\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#webpage\"},\"articleSection\":\"Event Notes, Configuration Manager, Event Notes, Events, System Center\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aidanfinn.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=14#listItem\",\"name\":\"Event Notes\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=14#listItem\",\"position\":2,\"name\":\"Event Notes\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=14\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#listItem\",\"name\":\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#listItem\",\"position\":3,\"name\":\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=14#listItem\",\"name\":\"Event Notes\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#webpage\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479\",\"name\":\"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro\",\"description\":\"Speaker: Saud Al-Mishari, MSFT PFE \\u2013 think he\\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12479#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"datePublished\":\"2012-04-20T18:02:55+01:00\",\"dateModified\":\"2012-04-20T18:02:55+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"name\":\"Aidan Finn, IT Pro\",\"description\":\"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro","description":"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL","canonical_url":"https:\/\/aidanfinn.com\/?p=12479","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aidanfinn.com\/?p=12479#article","name":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro","headline":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO","author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"publisher":{"@id":"https:\/\/aidanfinn.com\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=12479#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"},"datePublished":"2012-04-20T18:02:55+01:00","dateModified":"2012-04-20T18:02:55+01:00","inLanguage":"en-GB","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/aidanfinn.com\/?p=12479#webpage"},"isPartOf":{"@id":"https:\/\/aidanfinn.com\/?p=12479#webpage"},"articleSection":"Event Notes, Configuration Manager, Event Notes, Events, System Center"},{"@type":"BreadcrumbList","@id":"https:\/\/aidanfinn.com\/?p=12479#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aidanfinn.com#listItem","position":1,"name":"Home","item":"https:\/\/aidanfinn.com","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=14#listItem","name":"Event Notes"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=14#listItem","position":2,"name":"Event Notes","item":"https:\/\/aidanfinn.com\/?cat=14","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=12479#listItem","name":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO"},"previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=12479#listItem","position":3,"name":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO","previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=14#listItem","name":"Event Notes"}}]},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/#person","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=12479#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/?author=1#author","url":"https:\/\/aidanfinn.com\/?author=1","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=12479#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"WebPage","@id":"https:\/\/aidanfinn.com\/?p=12479#webpage","url":"https:\/\/aidanfinn.com\/?p=12479","name":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro","description":"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/aidanfinn.com\/#website"},"breadcrumb":{"@id":"https:\/\/aidanfinn.com\/?p=12479#breadcrumblist"},"author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"creator":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"datePublished":"2012-04-20T18:02:55+01:00","dateModified":"2012-04-20T18:02:55+01:00"},{"@type":"WebSite","@id":"https:\/\/aidanfinn.com\/#website","url":"https:\/\/aidanfinn.com\/","name":"Aidan Finn, IT Pro","description":"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","inLanguage":"en-GB","publisher":{"@id":"https:\/\/aidanfinn.com\/#person"}}]},"og:locale":"en_GB","og:site_name":"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","og:type":"article","og:title":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro","og:description":"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL","og:url":"https:\/\/aidanfinn.com\/?p=12479","article:published_time":"2012-04-20T17:02:55+00:00","article:modified_time":"2012-04-20T17:02:55+00:00","twitter:card":"summary","twitter:site":"@joe_elway","twitter:title":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO | Aidan Finn, IT Pro","twitter:description":"Speaker: Saud Al-Mishari, MSFT PFE \u2013 think he\u2019s based in the UK The session is on the new replication model: RCM, DRS, and SEDO. Key Concepts SQL replication in ConfigMgr 2012 is nothing do do with SQL Server Transaction Replication Data Replication Service (DRS) Terminology Stored procedure: sproc SSB: SQL Service Broker Change Tracking: SQL","twitter:creator":"@joe_elway"},"aioseo_meta_data":{"post_id":"12479","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 03:53:19","updated":"2025-06-04 15:04:02","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/?cat=14\" title=\"Event Notes\">Event Notes<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/aidanfinn.com"},{"label":"Event Notes","link":"https:\/\/aidanfinn.com\/?cat=14"},{"label":"MMS 2012: Deep Dive Into ConfigMgr 2012 DRS and SEDO","link":"https:\/\/aidanfinn.com\/?p=12479"}],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/12479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12479"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/12479\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}