Welcome to ciysys blog

Tracking the progress of a long run process

Published on: 3rd Jul 2012

Updated on: 17th May 2021


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?

Implementation strategy

Jump to #MSSQL blog


Lau Hon Wan, software developer.