I have a maintenance job running on my database (sql server 2016) which does an index reubuild on all tables including one large table ( 6 GB / 150.000.000 rows). I ran the job several times in the past and it always took around 3-4 hours to finish. This time however, it is already running more than 24 hours and I am wondering if this is normal. Should I just leave it running or should I interfere somehow?
- Activity monitor looks normal and indicates the rebuild is still running. Every couple of minutes it switches to blocked type but I guess that’s normal and it’s resolved fairly quickly:
- The log file stopped growing, but there is no maxfile size:
- Here is a picture of the active expensive queries:
- sp_whoisactive: