Microsoft

Microsoft Endpoint Configuration Manager Feedback

Suggestion box powered by UserVoice - Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

How can we improve Configuration Manager?

← Ideas

Improve automatic SQL configuration, tuning, and maintenance of the SCCM DB & SQL Server

Current architecture around SCCM’s management of SQL configuration and maintenance is old and hard to use. It requires a lot of manual oversight, and manual SQL tasks. And the default SQL settings created by SCCM are non-optimal. SQL is a powerful beast. Rethink ways SCCM can use it better, and keep it more optimally tuned and configured. Rethink how to run maintenance and backup tasks without downtime or impact to the production sites and deployments (this especially becomes more important with features like Conditional Access, that can never really have downtime.)

150 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Admindjam (Product Director, or Executive, Microsoft Endpoint Configuration Manager) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Noted  · 

5 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Garrett Marsh commented  ·   ·  Flag as inappropriate

    100% agree with this, SCCM and SQL should match what a CM RAP or SQL RAP would tell us to do and make the system perform better, multiple Temp DB's, Auto Growth on Temp DB, Optimize AD HOC queries, indexing, corruption check, DBCC, etc....

  • Steve Thompson commented  ·   ·  Flag as inappropriate

    I'd like to see tempdb and CM database files be properly created and sized depending on the estimated client count.

  • Steve Thompson commented  ·   ·  Flag as inappropriate

    Completely agree! Consider adding in Ola Hallengrens index and statistic optimization scripts to tune CM and SUSDB...

Ideas: Site deployment and infrastructure

Categories

Feedback and Knowledge Base

(thinking…)