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 […]
Tag: but there is no maxfile size: Here is a picture of the active expensive queries: sp_whoisactive:
Categories
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 […]