ConfigMgr DRS Synchronization Internals

Hi Folks, If you are managing a hierarchy for sometime and dealt with Replication issues before; I assume you would have an understanding of the DRS Initialization process. If you feel you need some guidance then refer: ConfigMgr 2012 DRS Initialization Internals But what is very obscure and often called a Black box is the…

3

ConfigMgr Software Updates Deployment (Assignment) & Individual Updates Compliance FAQs

What is the difference between Update Deployment (Assignment) and Update (individual) compliance reporting ? Consider a deployment containing 100 updates. Now each of these 100 updates will have their own compliance state on the machine and the Deployment you can say is a collective compliance of each of them. Meaning that until all of the…

2

The case of (Un)Explained :ConfigMgr SQL Always ON – Upgrade to 1902 with Certificate backup Error using Listener Name

Hi there! Here is an interesting one (in case you encounter one), Where the upgrade to 1902 for a SQL AO infra was failing with the below error – CONFIGURATION_MANAGER_UPDATE    28292 (0x6e84)    Create_BackupSQLCert : SQL server failed to backup cert. CONFIGURATION_MANAGER_UPDATE    28292 (0x6e84)    CSiteControlSetup::SetupCertificateForSSB : Failed to create/backup SQL SSB certificate. CONFIGURATION_MANAGER_UPDATE    28292 (0x6e84)    ERROR:…


Demystifying the Native SQL Replication co-existence issues with Resident ConfigMgr DRS

I think it is very common resident knowledge with experts who work on the cases involving Native SQL replication with ConfigMgr DRS (Be it MP Replica DB, or just plain out of box SQL Replication usage in ConfigMgr infra) “The Configuration works well until it breaks in way so bad that DRS is non-functional with…


ConfigMgr Current branch (1810+) guidance for the SQL CE levels with various SQL versions

Hi Folks, So first things first before I bombard with Jargons on SQL to a non-SQL ConfigMgr admin. What is CE or Cardinality Estimation? The CE predicts how many rows your query will likely return. The cardinality prediction is used by the Query Optimizer to generate the optimal query plan. With more accurate estimations, the…

1

ConfigMgr 1702+: Adding a new node (Secondary Replica) to an existing SQL AO AG

Scenario: We already have a working Primary and secondary replica and we know that ConfigMgr 1702 does support an extra replica i.e. 2nd Secondary replica. So we are adding a freshly built node as a secondary replica.   The documentation we have around this can be found below. https://docs.microsoft.com/en-us/sccm/core/servers/deploy/configure/configure-aoag#add-and-remove-replica-members To add a new replica member…

3

ConfigMgr 1702: DRS Activation SPROCS Internals (with Case Study)

    Hi Folks, To start with explaining this topic a small background on what is Activation. This is purely a SQL Service broker term. The messages when they are placed in the queue need to be processed, so as a message is placed SQL SSB has an Activation Stored procedure defined which is launched…

2

ConfigMgr CB: ‘Delete Aged Discovery Data’ Internals (with Case Study)

Hi Folks, Many a times we do get cases where the Delete Aged Discovery Data is not deleting the records that we expect it to delete. So here are some findings that are not documented and I have had quite a few cases. Starting with where do we set it; Pretty easy as everyone knows…

1

ConfigMgr 1702: The case of unexplained – Client Peer cache not getting disabled even after disabling it via Client Settings

  Hi Folks, I am back with the unexplained series. Today being the discussion on the new feature called Client Peer Cache introduced in ConfigMgr 1610. Even though the issue in the blog talks about Client Peer Cache still in use when disabled, We will first try to understand the background and some semantics of…

10