SQL Server recommendations for Microsoft Endpoint Configuration Manager environment – White Paper

Introduction  As a Premier field engineer at Microsoft, we field many questions about SQL configuration for Configuration Manager environments, so we’re writing this to address some of them here. Questions are often along the lines of “How should I properly configure SQL database settings in a Configuration Manager environment for the best performance?”, “What maintenance … Continue reading SQL Server recommendations for Microsoft Endpoint Configuration Manager environment – White Paper

System Center Configuration Manager – "Configure SQL Server Service Broker Failed"

The Issue Recently I installed the Latest Tech Preview in my lab environment and while running an In-Console update I received an error "Configure SQL Server Service Broker - Failed". The Investigation If you watch a video Steve Rachui posted some time ago, there are some valuable tips for which logs to review and the … Continue reading System Center Configuration Manager – "Configure SQL Server Service Broker Failed"

SCOM: MSSQLServer Event ID 28005

Hey everyone, Theron (aka T-) here, Senior Consultant with Microsoft Consulting Services (MCS) specializing in Active Directory, but also dabbles with all things Systems Center. Recently, while implementing SCOM 2019 in a customer's environment, I ran into an issue when trying to install agents; the discovery wizard would never complete the 'discovery' process. After making … Continue reading SCOM: MSSQLServer Event ID 28005

SCOM DB Fragmentation Issue

Sometimes SCOM environments slowness is occurring because of SQL fragmented indexes. Fragmentation happens when the logical order of pages in an index does not match the physical order in the data file. Because fragmentation can affect the performance of some queries, you need to monitor the fragmentation level of your indexes and, if required, perform … Continue reading SCOM DB Fragmentation Issue

System Center Configuration Manager – Upgrade to 1902 Error – “SQL Server Configuration for site upgrade”

The issue: After trying to upgrade a client Configuration Manager Environment from 1810 to 1902 the upgrade failed with the error “SQL Server Configuration for site upgrade”. The first thing that crosses your mind is the SQL version is wrong or the memory is not configured correctly. But in my case SQL was SQL Server … Continue reading System Center Configuration Manager – Upgrade to 1902 Error – “SQL Server Configuration for site upgrade”