Use this
DB::connection('sqlsrv')->statement('SET SHOWPLAN_XML ON;'); DB::connection('sqlsrv')->statement('SET SHOWPLAN_XML OFF;');
SHOWPLAN_XML to capture the execution plan without running the query