Share via

SCCM installation

matteu31 467 Reputation points
2020-11-05T14:08:04.343+00:00

Hello,

I'm trying to automate SCCM installation and for this, I try to find best practice.
I have an issue about SQL. Lot of different things can be found...

1)How much file for data is needed ? Sometimes I see 2 and sometimes 4.
2)How much file for tempdb data is needed ? In microsoft documentation for memCM, I can see 4 and in whitepaper microsoft sql recommandation as much as core processor.
3) Does this excell file is still ok for sizing ? https://blog.ctglobalservices.com/configuration-manager-sccm/kea/system-center-2012-configuration-manager-sql-recommendations/
4) Does tempdb autogrowth need to be turned off if it's on dedicated disk drive ?

5)I see in youtube video (patch my pc) installation with 8 disk drive :

  1. c: system + sql binaries
  2. d: sccm binaries
  3. e: sccm DB data
  4. f: sccm DB log
  5. g:temp DB
  6. h:wsus db
  7. i:source file (if SCCM server host application, packages, osd, ...)
  8. j:content library

I suppose I can use NTFS on all disk except e+f+g REfs with 64ko right ?

Finally, I often install SCCM on customer with less than 10K devices. Do I need to follow all of these advices or they will never be difference because it's not enough devices ?

Microsoft Configuration Manager
0 comments
Accepted answer
  1. Fiona Yan-MSFT 2,311 Reputation points
    2020-11-06T03:06:11.203+00:00

    @matteu31

    Thank you for posting in Microsoft Q&A forum.

    The above we considered could be expected and our thoughts are also very comprehensive,for our point 4, If we have a logical drive dedicated for TempDB data and log files, consider filling the drive with the TempDB data files and turning off file Autogrowth.For our point3,the article is also could be used.
    But it seems to be more related to SQL issues,at such situation, to get better support, it is suggested to contact SQL server support to see if they have some comments about this, as they may have more resources about the SQL.Our SQL could support many application with it,SCCM is the only one of these apps,so I appreciate your understanding that we are not the best channel to address this issue since the forum is mainly focusing on SCCM simple break-fix issues.

    To obtain the contact methods for specific SQL technology request please take a look at the web site listed below:
    https://learn.microsoft.com/en-us/answers/products/sql-server

    Thank you very much for your kind understanding and have a nice day!

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. matteu31 467 Reputation points
    2020-11-06T06:45:42.057+00:00

    Hello,

    Thanks for your answer.
    Do you think all this customisation is needed on environment with less tha 10kk devices or it s more related to 30/50/70k devices ?

    0 comments
  2. matteu31 467 Reputation points
    2020-11-09T09:56:44.107+00:00

    Maybe someone can help me to know if it's oversizing or not to use all these volume for 2k devices only in SCCM and all can be done in only D: ?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.