[글쓴이:] borlbd

SELECT session_id as SPID, command, a.text AS Query,start_time, percent_complete,DATEADD(second,estimated_completion_time/1000, GETDATE())AS estimated_completion_timeFROM sys.dm_exec_requests rCROSS APPLY sys.dm_exec_sql_text(r.sql_handle) aWHERE r.command = ‘RESTORE DATABASE’

SELECT TOP 20 [Average CPU used] = total_worker_time / qs.execution_count ,[Total CPU used] = total_worker_time ,[Last CPU used] = last_worker_time

Windows 버전/SQL 버전 –> SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL