cancel
Showing results for 
Search instead for 
Did you mean: 

Memory consumption of a procedure

former_member185511
Active Participant
0 Kudos

Hello,

Is there a way to check the memory consumption of a procedure ? I tried tracing, expensive statements etc but i cannot see how much memory is consumed during calculations. (like average/peak values).
If i go back to system overview i can see memory consumption is increasing but i want more detailed information related to specific procedures.

Accepted Solutions (1)

Accepted Solutions (1)

SergioG_TX
Active Contributor
0 Kudos

Bilen,

you can do a plan visualizer.. on your SQL console, highlight your stored proc call statement and right click on it. then click on visualize plan. you may have to execute then visualize. once the plan visualizer runs, you will see where the memory consumption for this stored procedure happens.

same process you can do for troubleshooting the memory consumption from your views

hope this helps!

former_member185511
Active Participant
0 Kudos

thank you sergio aguero last time i checked here but couldn't see, now i check more detail and i saw on the statement statistics tab after executing.

former_member185511
Active Participant
0 Kudos

it is weird,

plan visualizer shows 330MB if i aggregate all the TOTAL MEMORY column

if i refresh overview from server total difference is 23GB during procedure RUN strange.

Answers (0)