I am executing the rebuild index script in SSMS to rebuild a specific primary key index of a major table in our database. It has been running for 13 hours now.
sp_who2 shows me that it was suspended due to
IO_COMPLETION wait type.
Now I don't have any idea to how to deal with the situation.
- What is
- How can I make this job runnable from suspended?
- Can I kill the reindex job SPID and plan it for some other time? I heard that it's not a good idea as it will take a lot of time to rollback.
When I check to see the percentage of completion of rebuilt index with some query using
exec_sql_request, it is showing ZERO. Now the physical reads = 310,777,191. A while later the physical reads = 319,741,497.
How long should we wait and let it run? Is there anyway to get/see an estimate?
The table contains 8 billion records. It was fragmented 80 percent.