Gonna be brutally sincere below: it doesn’t audio like you’ve been to a SQL Server education class in the final ten years. That variety hasn’t been helpful due to the fact probably 2000.
Other than fragmentation https://nicolepmxk471011.acidblog.net/61142251/sql-server-health-check-company-an-overview