coolchaitu (9/24/2016)
Good morning Experts,Index maintenance job got stuck in suspended state. It has been in that state for more than 3 hours and is not making any progress. I checked the waittype and it is showing as PAGEIOLATCH_SH. What should i do to get the job running?
The PAGEIOLATCH_SH is telling you that the procedure is waiting on pages to be read. It may or may not be a problem.
What index maintenance job are you using? Maintenance plans? :sick: Ola's scripts? Minion? Your own? Other?
What's the normal execution time for your index maintenance?
Have things changed significantly since the last time you ran it?
Do you know what it's doing right now? If it's been stuck on a 100-row table for 3 hours, you may have a problem with your disk. On the other hand, if you're processing a 1 TB database and it's been waiting for reads on a bunch of tables for the last 3 hours, you may be fine. This points back to what's a normal run time for the job.