We help IT Professionals succeed at work.

What is the event to track for memory usage in SQL Profiler?

saratcm
saratcm asked
on
Hi All,
What is the event I have to select in profiler to tract the memory usage by eack task?
Comment
Watch Question

SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019
Commented:
Unfortunately, you can't track or monitor Memory usage in Profiler and hence you can use DBCC command which is mentioned above
or
Use Perfmon to capture Memory related performance as mentioned here:

http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

Author

Commented:
Thanks Guys

Author

Commented:
Can one of u help me with my other question on replication?