Categories
Database Development

Index rebuild not finishing

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:

Leave a Reply

Your email address will not be published. Required fields are marked *