Thursday, 3 June 2010

TSQL : % Percentage complete of running requests

SELECT percent_complete ,*
FROM sys.dm_exec_sessions s
INNER JOIN sys.dm_exec_requests r
ON s.session_id = r.session_id

MSSQLTips : Finding a SQL Server process percentage complete with dynamic management views

Update 14/06/2011 - Sweet SQL Lass has a version to show backup/restore progress. It nicely casts the time elapsed and remaining into minutes too. Sweet SQL Lass : How far has my backup/restore got?

1 comment:

Kishore Jandhyala said...

Nice article.

I was looking for something like this sometime back, unfortunely i could not find something like this.