Orio has index defragmentation in Database Maintenance task, but it's turn off by default see SolarWinds Knowledge Base :: Critical index fragmentation detected during database maintenance.
This will trigger index defragmentation without turned off services, but this feature is more suitable for online index rebuild feature in SQL server.
If your database manager prefer offline way, then provided steps are correct.
Thanks Tomas, good to know.
Regarding online index rebuild (offline) procedures I mentioned in my original post, our DBA is finding that rebuilds (offline) are failing when attempted from SQL Server Management Studio. Databases were confirmed in single-user mode, so not sure why they would fail and I don't have error details, so I passed along the article on setting the auto index setting enabling it.
can you post SQL error which DBA faced here?
Thank you TP