Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server

Taikoma: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Enterprise Core

Summary


Currently in Microsoft SQL Server, the sp_MSsubscription_cleanup stored procedure is executed by the sp_MSdistribution_cleanup stored procedure. This, in turn, is executed by the distribution cleanup job.

However, the resource usage of the sp_MSsubscription_cleanup stored procedure is very high: it may take several minutes to complete, and the frequency of the distribution cleanup job is 10 minutes. This means that this costly stored procedure runs every 10 minutes with a duration of several minutes.

This update makes the following changes:

  • The costly sp_MSsubscription_cleanup stored procedure is executed by the sp_expired_subscription_cleanup stored procedure. This, in turn, is executed by the Expired Subscription Clean Up job.

  • The Expired Subscription Clean Up job runs every 24 hours. Therefore, the costly sp_MSsubscription_cleanup stored procedure will run only one time per day.

Resolution


References


Learn about the terminology that Microsoft uses to describe software updates.