Brian Chaplin

Subscribe to Brian Chaplin: eMailAlertsEmail Alerts
Get Brian Chaplin: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Brian Chaplin

Many reporting applications use stored procedures that sometimes take a while to run. Even with fast database servers, response time can be measured in minutes after your best efforts at tuning. Users who are used to seeing progress bars on their Internet downloads expect a similar visual clue from their database applications. How do you monitor and display the progress of a long-running stored procedure? Solution A straightforward solution to this problem is to have the stored procedure update a status table as it progresses through each step. Open up another connection to the database and display the results from the status table on a periodic basis until the stored procedure completes. How to Implement Although the concept is straightforward, each step has its nuances. I'll detail the 14 steps and add a fifteenth one for extra credit. These steps were developed w... (more)

Monitoring the Progress of a Long Running Stored Procedure

Many reporting applications use stored procedures that sometimes take a while to run. Even with fast database servers, response time can be measured in minutes after your best efforts at tuning. Users who are used to seeing progress bars on their Internet downloads expect a similar visual clue from their database applications. How do you monitor and display the progress of a long-running stored procedure? Solution A straightforward solution to this problem is to have the stored procedure update a status table as it progresses through each step. Open up another connection to the ... (more)