What SQL maintenance should I perform on my SCOM 2016 databases?

<!--[if lt IE 9]>

<![endif]-->

Comments

• Anonymous
  August 03, 2017
  Kevin, great post as always! Strongly recommended read for all our customers. I have updated the SCOM 2012R2 Survival guide with a link to this post: https://social.technet.microsoft.com/wiki/contents/articles/20796.system-center-2012-r2-operations-manager-survival-guide.aspx
• Anonymous
  August 25, 2017
  An excellent article; thank you. I noticed today that my main OperationsManager database was using an additional 2.7 GiB per day, since upgrading to SQL Server 2016 last week. A re-index has just freed 25 GiB.
• Anonymous
  February 03, 2018
  Thanks kevin :)