2020 Q2 featured KB article - For Tridion Sites 9.1 and earlier versions, how to remove unnecessary data in the state store database?

Every few months, SDL Support will feature one of the Tridion Sites KB articles from the SDL Gateway. This month, an article on how to remove unneeded data from the Deployer state store tables was selected. Visit the Tridion Sites KB to see other articles written by our support engineers when helping customers. Subscribe to the Tridion Sites newsletter to receive a quarterly update on important product announcements and other technical information.
Administrators will sometimes see that bulk publishing fails, is slow, will partially fail, or result in high CD server CPU utilization. This is sometimes due to a buildup of state store table data in the broker database. See KB article 000010734 for a detailed description of the issue and steps to resolve.