I was going to do a write-up on how to optimize the SQL database for ConfigMgr and I found someone that had already written a great walkthrough for people who aren’t that familiar with SQL.
You can view Steve Thompson’s original post HERE.
With a follow-up with more detail for non-SQL people by the same blogger HERE.
SQL Server scripts provided by Ola Hallengren. View his website HERE. Be sure to modify his script as shown by Steve Thompson.