Deep-dive SQL Server performance analysis — query optimization, indexing strategy, wait stats diagnosis, and prioritized tuning roadmap.