So I noticed over the past month that System Center Configuration Manager is running a bit sluggish which immediately indicates to me that it’s time for some maintenance! (sigh)
For those who manage programs such as SCCM and SCOM which require modern versions of SQL Server, this custom script created by Ola Hallengrens is a must have! Also, be sure to check his site periodically as he does a great job of updating this script along with others on a regular basis. Paired with additional recommendations from Steve Thompson designed for these specific programs, I am pleased with its effectiveness in cleaning up these SQL databases.