Measure memory usage using profiler?

Question

Measure memory usage using profiler?

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
May 21, 2011 at 7:08 pm

#148101

I am trying to find memory usage for a specific proc when it is ran. I have a test server with literally nothing running on it. I need to know when i am running a specific proc how much much is it using. Is there a way to find using profiler? I would really appreciate if somebody can advice me with the counter names which i can use. Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27164 More actions · Answer 1

Use perfmon and explore "Memory" & "SQL SERVER:Memory Manager" counters.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

BLOB EATER SSChampion Points: 14609 More actions · Answer 2

im sure that there is a Server Memory Change event class (tick all events when in profiler)

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 3

arun_sql (5/23/2011)
im sure that there is a Server Memory Change event class (tick all events when in profiler)

Thanks. I selected that event as you said but didn't find anything logged at all. Could it be because the sproc which i was testing on didnt need more memory than assigned? This is from profiler trace definition "Indicates when SQL Server memory usage increases or decreases by 1 megabyte or 5% of the maximum server memory, whichever is greater.". Does it log only when it needs more memory than assigned?