I will be installing the a single-server SCCM 2012 R2 for a small environment.  I will use SQL 2012 or 2014 (not sure if upgrade from SQL 2012 to SQL 2014 is included in the SCCM package purchased) and everything will be on a single Server 2012 R2 with 2 SSD drives in RAID 1.  I plan to partition the C drive for Windows and then SQL and SCCM will all run on the D partition on the SSD.

The instructions I have found for installing System Center Configuration Manager 2012 R2 didn't go into much detail on setting up SQL other than configuring the maximum RAM setting.

Are there any recommended SQL configuration optimizations for a new SQL install that will be used only for Config Manager 2012 R2?

What about recommended scheduled maintenance and backup tasks?

• Edited by MyGposts 5 hours 49 minutes ago

To prevent the C drive from running out of space based on any future growth of the database. 

Having separate partitions will protect the free space on the C drive.

I double checked the drives and it will be 3 480GB drives, so it will need to be RAID 5 instead of RAID 1.

It will just be a few hundred clients.

• Edited by MyGposts 1 hour 53 minutes ago