What is the Maximum amount of Memory I should configure SQL to use for a SCCM Site Database Server? To avoid potential performance problems, you have to configure SQL to use the correct maximum amount of memory depending on where … Continued
What is the Minimum amount of Memory I should configure SQL to use for a SCCM Site Database Server? To avoid potential performance problems, you have to configure SQL to use the correct minimum amount of memory for the type … Continued
How can I see how much disk space each Table in the SCCM Site Database is using? It can be useful for health check and troubleshooting purposes to see the size of the tables in the ConfigMgr Site Server database. … Continued
What SQL Database Collation do I have to use for SCCM? You have to be very careful that you choose the correct SQL Database Collation for ConfigMgr otherwise you’ll have all manner of problems.
What are the different Versions Numbers for Microsoft SQL Server? Over the years Microsoft has released various versions of SQL Server, each with its own version number which are detailed in this FAQ.
How do I install SQL Server 2014 for SCCM Current Branch? In this 30 page guide we walk you through step-by-step how to install Microsoft SQL Server 2014 with SP2 for ConfigMgr Current Branch (CB) / LTSB.
How can I see a list of all SCCM Components installed on a computer without using Configuration Manager Service Manager? Using Configuration Manager Service Manager to see the ConfigMgr components installed on a computer can be a pain. Here’s a … Continued
Does SQL 2014 capture the installation process in a log somewhere? So you’ve just installed SQL Server 2014 but want to check the settings you selected during the setup wizard and if there were any errors. Is there a log … Continued
How can I see a specific Logging setting for a SCCM Component without using ConfigMgr Service Manager? Using the Configuration Manager Service Manager to check a specific logging setting for a ConfigMgr component can be fiddly. So here’s another way … Continued
Why is the SCCM Site System Role I want to install not listed in the “Add Site System Roles Wizard”? I am trying to install an additional ConfigMgr Site System Role on a server that is already hosting a Site … Continued