troubleshootingsql.com
A shot in the arm for sp_purge_data
I had recently worked on a performance issue with the Management Data Warehouse job “mdw_purge_data”. This job calls a stored procedure sp_purge_data which was taking a long time to complete. This …