I am trying to rebuild Indexes including system indexes and it runs for about 10 minutes and then just stops.
I have left it for several hours and the trace file from SQL Server just does not increment, it is as if the process just hangs.
The database is SQL Server 2016 on Amazon RDS. I have run trace files for other operations like compress database and that works.
Here is the link to what I am following but adapted for our database connection details:
Any ideas on what to do next?