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.