I have a SQL server 2005 SP2 and is installed on a dedicated windows box.
I am referring to the below URL: http://msdn.microsoft.com/en-us/library/ms190924.aspx
I am trying to monitor the amount of memory used by SQL server at any point of time.
I am trying to understand the below 2 parameters: Target Server Memory (KB) --> Total amount of dynamic memory the server can consume.
Total Server Memory (KB) --> The committed memory from the buffer pool (in kilobytes). Note: This is not the total memory used by SQL Server.
As per my understanding, Total Server Memory (KB) is max amt of memory SQL server can use BUT is NOT the amt of memory SQL server is using right now.
Options that I found: 1) select * from sys.dm_os_performance_counters where counter_name like '%server memory%' 2) Check SQLSERVER.EXE from TASK MANAGER.
So HOW can I find out amt of memory that SQL server is using? I need to find the exact memory usage which may keep on changing at any point on time.
NEED HELP ASAP!!!!