• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

Query sys.dm_os_process_memory

Hi,

I want to query sys.dm_os_process_memory  in SQL 2008. Can anyone tell me the exact process.

Thanks.
0
Sid_F
Asked:
Sid_F
1 Solution
 
PadawanDBAOperational DBACommented:
When you say exact process, what's the scope of what you're looking for?  From click start to execute or just the query?
0
 
lcohanDatabase AnalystCommented:
select * from sys.dm_os_process_memory  

or use DBCC MEMORYSTATUS
or see more at

http://blogs.msdn.com/b/sqlsakthi/archive/2011/02/28/t-sql-script-to-monitor-memory-usage-by-sql-server-instance.aspx
0
 
Sid_FAuthor Commented:
Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now