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