Hi, I am having an issue where my DB restore and shrink operations are going REALLY slow. When I run “select * from sys.dm_exec_requests” I am able to find the row representing my operation. Most of the time it looks like the “percent_complete” field is not increasing, and the “wait_type” field says “PAGEIOLATCH_SH”. Does anyone know what this means?
This is causing some real setbacks for our team so we are hoping to get help ASAP. Thanks, in advance!