I'm setting up a new SCCM site from scratch. It will be 2012 R2 SP1 CU1 with SQL Server 2014 SP1.
I followed online documentation on how to install it and I successfully installed it in a lab, however, I need to know what to change from defaults in the SQL setup for production. The server will be Server 2012 R2 running SQL and ConfigMan 2012 R2 SP1 CUI on a single box with 32GB RAM and SSD drives.
The site will have less than 500 clients.
I plan to set the minimum SQL memory at 8GB and maximum at 28GB. That setting is the only required setting for SCCM to successfully install, but what about other settings for optimization?
What settings should be set to optimize SQL performance manage the database and log size to prevent the drive from filling to capacity?
What are SQL configuration recommendations for a 500 client site and around 500GB disk space?
There will not be 500 clients starting out. I will likely start with less than 200 clients and grow to up to 500 over several months.
This is what is set by default in the lab install. Is this all that needs to changed or are there other settings?