on 03-08-2016 3:09 PM
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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.