You can use this tool to see exactly where SQL Server uses the most time running the query Analyze an Actual Execution Plan - SQL Server | Microsoft Learn