Hi Jeffrey,

Yes sure, I ran the query to determine the index fragmentation before and after the maintenance plan and I saw that all those that were above 0 were changed...

Hi Jeff,

Because I saw in the task execution log file that the rebuild queries that were performed only affected the indexes with fragmentation greater than 0%. Nothing was done for...

The heaviest clustered index is around 8 Gb while the database weighs 17 Gb.

Thanks Jeff.

Because rebuilding the indexes considerably increases the size of the database.

And over time it could be a problem.

Hi Jeff,

I set it to 0,

And please, could you answer the other question I asked?

Thanks.

Yes Anthony,

It was just the MAXDOP  set to 2!! Now it's back to working properly.

Also analyzing the differences with the previous server, I noticed that the Full-Text Upgrade Option property...

No, there is only one instance in the virtual machine.

We also add that I tried to give 8 processors and 8 sockets to the machine and the cpu was blocking...