Gonna be brutally genuine right here: it doesn’t sound like you’ve been to your SQL Server schooling course in the last decade. That variety hasn’t been beneficial since probably 2000.
Aside from fragmentation https://izaaklshg933117.getblogs.net/62416791/a-review-of-sql-server-health-check-company