![](data:image/svg+xml;charset=utf-8,<svg height="31" width="156" xmlns="http://www.w3.org/2000/svg" version="1.1"/>)
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 […]