Use statistics profile to analyze the actual operation of query

You can use statistics profile to record detailed procedures and statistics for the actual operation of query. For example, the following SQL can record the operation and execution plan for each step of the stored procedure:

SET STATISTICS profile on
go

[dbo].[ Youstoredprocedure]

In addition, if you use a temporary table that is not previously defined in a stored procedure, viewing the execution plan will cause an error. It's OK to turn off the execution plan at this point.

Set SHOWPLAN_TEXT off Go Set STATISTICS profiles on Go

[dbo].[ Youstoredprocedure]