You can analyze a slow SQL query through the following ways:
View the statistics of the SQL query in the
sql_audittable and analyze its SQL execution plan.
For more information, see Analyze SQL queries that cause an abrupt RT jitter.
Verify whether the execution plan is correct. For more information, see View the shape of an execution plan and analyze the plan.