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
In the continuation of the ConfigMgr\MEM series, our next session is going to be looking at Database Performance, how this impacts the system, and what you can do to optimize what you have. The SQL Server component is easily the busiest part of MEM, and slow database performance is something that I run into on … Continue reading ConfigMgr\MEM 101: 5 Tips for Improving SQL Performance
The Issue Recently I was at a customer that had a very strange and specific requirement. They wanted to query All File Type Extensions with a count on all machines in the environment. This was an environment with 30 000+ machines and they wanted it to run quickly and once off. The Investigation System Center … Continue reading Powershell – "Search and Count All File Extensions on Multiple Machines using Powershell"
This will be the second part of a new series of posts, regarding different topics in ConfigMgr.ConfigMgr can be a daunting product to use, and especially to someone new to the product (or even some old hands).To simplify some of the concepts, and to assist you in better understanding, and ultimately using the tool more … Continue reading ConfigMgr 101 – Understanding Backups (Part 2)
This will be the first part of a new series of posts, regarding different topics in ConfigMgr.ConfigMgr can be a daunting product to use, and especially to someone new to the product (or even some old hands).To simplify some of the concepts, and to assist you in better understanding, and ultimately using the tool more … Continue reading ConfigMgr 101 – Understanding Backups (Part 1)
This is a question I have had since I started with SCCM 2007. I thought I had a grasp of it until I was talking with a customer and started second guessing myself. Why aren't all my updates installing during the Maintenance Window? Why do I have Servers in a Reboot Pending State after our … Continue reading Configuration Manager – How Updates install during a Maintenance Window.
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"
Recently I was helping a customer who was having a challenge with software updates in that some of their endpoints were installing software updates the day that updates were made available and not waiting until the deadline was set. After verifying that the software update deployment was setup correctly as shown below: We confirmed that … Continue reading Configuration Manager: Software Updates install before deadline???
Background Occasionally we may receive the following alert: SSRS 2012: There are misconfigured data sources Gentleman, Start your hacking So let’s rip open the MP and see what’s going on. After going recursively bottom to top I finally understood that this is the DataSource being referenced in the monitor/probe: <ProbeActionModuleType ID="Microsoft.SQLServer.2012.ReportingServices.ProbeAction.TSQLCountersReportingServiceCustom" Accessibility="Internal" Batching="false" PassThrough="false"> And … Continue reading SSRS – There are misconfigured data sources
The Issue Recently I was posed a question where a customer wanted their users to experience a more advanced or informative when software gets installed. They also required that data be saved so that users work are not affected. Requirements: The Mimecast for Outlook add in had to be installed (This requires Outlook to close) … Continue reading Infrastructure – System Center Configuration Manager – “Deploying applications with the PowerShell Application Deployment Toolkit”