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: enter image description here
  • The log file stopped growing, but there is no maxfile size:
    Data File IO
  • Here is a picture of the active expensive queries: picture of the active expensive queries
  • sp_whoisactive:
    spwho
    spwho2

Leave a Reply

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