I need to improve performance of an SP. This SP calls another SP which is consuming 80% of time. I collected this info by inserting INSERT statement before call to inner SP. Both the outer and inner SP's are using CURSORS. Problem: I can not change the code of inner SP. Questions: Was my method of collecting processing time by inserting INSERT statement correct? Any better idea? Is there a way to find CPU cycles of both outer and inner SP. I have tried INDEX defragmentation by DBCC REINDEX, but this has not improved performance by 5%. Any other suggestions?