Thanks a lot on your response !

Btw I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and showed an error :

/*********************************************..." failed with the following error: "Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

at the moment there are still 10 indexes that need to be rebuilt...

I am thinking to drop some unused indexes and filter by page_count which is above 300

Any idea about this issue ?

Thank you

Cheers