Monday 30 May 2011

backup status for 2005 only

SELECT
r.percent_complete
,r.estimated_completion_time
,r.total_elapsed_time
,convert(varchar(10), (r.total_elapsed_time%3600000)/60000) + ' Mins  '
,datediff(mi,start_time,getdate()) /60.00 'Hs'
,physical_io
,P.CMD
,DB_NAME(p.DBID)
,t.text
,P.*
from sys.dm_exec_requests  r
join sys.sysprocesses p on r.session_id = p.spid
cross apply sys.dm_exec_sql_text(p.sql_handle)  t

No comments:

Post a Comment