Microsoft SQL Server performance analysis

Start SQL Server Profiler from Management Studio:

Add a column filter, e.g., to the "Duration" column to display all queries that take longer than 500 milliseconds:

Select a query from the log and copy the query text:

In Management Studio, click the "New Query" button, paste the copied query text into the new query tab, and activate the "Include execution plan in output" function:

After execution (1.), another tab, "Execution Plan" (2), appears at the bottom.

In the execution plan, you can see the individual operations of the SQL Server and their utilization in detail. If necessary, you will also receive information about missing indexes or similar issues here. This can help you determine why the execution is taking so long.

If your query is an update or insert, you may also see the stored trigger activities here, and in the case of a select, the stored table joins of a view.