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