First published on MSDN on Jan 17, 2017
In the
first part
of my Change Tracking Cleanup post, I talked about how automatic and manual cleanup happens in SQL ...
Updated Mar 23, 2019
Version 2.0
Blog Post
i know this is an old post. hope someone could shed some light for me.
I've recently taken over the sccm in my new joined company. And found that we have a few Billions change tracking record that have not been cleaned for the past 6 years due to unknown reason.
i've been running this script for weeks but it's not running fast enough, it may take months for me to finish as only 5000 rows are deleteing during each call by the sp.
Is there any method i can increase the 5000 number to a higher number? there are plenty of resources for this SQL db, i would like to increase the number to speed up the process.
thanks,
Derwick