A universal way to track the progress of a long run process


Overview

Have you ever wondered what is the current progress of an active long run process? The following solution will help you in tracking the long run process in a stored procedure or even C# program.

For example, you have a stored procedure that requires you to run at least 30 minutes and the DBA wants to be able to see the current progress. Sounds magical?

9th Jul 2025: regardless of which database engine that you use, this idea still applicable.

Implementation strategy

Back to #MSSQL blog

Back to #blog listing