How to find the root cause of performance for stored procedure

1. Add log for the sp and find which step has the high cost.

2. If the step is static sql use <<How to find the root cause of performance for SQL>> to found the root cause.

3. If the step is used SESSION table, we use tmp table replace the static table or there is a method that can get execute plan of SP include SESSION table.