在SQL Server 2012(11.0.7001.0)下面在还原一个数据库(备份文件40多G大小,实际数据库大小300G),在还原过程中,出现一直等待ASYNC_IO_COMPLETION,如下测试截图所示,已经等待了72分钟了,但是还原比例依然为0% SELECTr.session_id , r.command , r.start_time, r.status, r.wait_type, CONVERT(NUMERIC(6, 2),...
在SQL Server 2012(11.0.7001.0)下面在还原一个数据库(备份文件40多G大小,实际数据库大小300G),在还原过程中,出现一直等待ASYNC_IO_COMPLETION,如下测试截图所示,已经等待了72分钟了,但是还原比例依然为0% SELECT r.session_id , 1. r.command , 1. r.start_time, 1. r.status, 1. r.wait_type, 1. ...
r.wait_typeasCurrent_Wait_Type, r.wait_time/1000/60/60aswait_h, r.status, r.command, r.total_elapsed_time/1000/60/60astotal_h, r.percent_complete, r.estimated_completion_time/1000/60/60asestimated_hfromsys.dm_exec_requests routerAPPLY sys.dm_exec_sql_text(r.sql_handle)asstwhere(r...
WaitType:ASYNC_IO_COMPLETION 项目组有一个数据库备份的Job运行异常,该Job将备份数据存储到remote server上,平时5个小时就能完成的备份操作,现在运行19个小时还没有完成,backup命令的Wait type是 ASYNC_IO_COMPLETION: 根据MSDN 官方文档的定义:Occurs when a task is waiting for asynchronous I/O operations to f...
Normally this wait type can be seen in backup and restore transactions, and whenever you will see this wait type your backup/restore process will be in suspended state most of the time because the process is waiting to get IO resource to proceed its operation and it will wait till certain ...
up storage/disk/infrastructure because we're seeing this ASYNC_IO_COMPLETION lastwaittype. But you're saying that isn't true. This lastwaittype is normal for a backup job. If that is the case what should we be looking at the understand why we're seeing an increase in the backup time?