November 21, 2011 at 5:44 pm
Hi,
This may sound like a repeated question, but I could not find a single solution that answers it all.
How to find out the amount of memory used by Sql Server and other processes on a 64 bit and 64 GB machine with Win2008.
Task Manager is not reliable
Total Server Memory from PerfMon counters is not correct (as indicated on the BoL http://msdn.microsoft.com/en-us/library/ms190924.aspx )
Please help,
_Ub
November 22, 2011 at 9:24 am
November 23, 2011 at 3:11 am
_UB (11/21/2011)
Hi,This may sound like a repeated question, but I could not find a single solution that answers it all.
How to find out the amount of memory used by Sql Server and other processes on a 64 bit and 64 GB machine with Win2008.
Task Manager is not reliable
Total Server Memory from PerfMon counters is not correct (as indicated on the BoL http://msdn.microsoft.com/en-us/library/ms190924.aspx )
Please help,
_Ub
Task Manager & PerfMon, both are reliable. They show the SQL Server Memory utilization at the moment. But SQL Server is bit lazy in releasing memory. It releases memory when OS / other applications need it. So for 64GB RAM if SQL Server is currently consuming 50GB, it won't release the memory until requested by OS.
Dynamic Memory Management
November 23, 2011 at 5:22 am
Hi _UB
In order to get information on total memory used then there are two sources of information
(a) DBCC MEMORYSTATUS (see http://support.microsoft.com/kb/271624)
(b) sys.dm_os_process_memory ( see http://www.sqlservercentral.com/blogs/glennberry/archive/2010/04/23/a-dmv-a-day-_1320_-day-23.aspx)'
This needs SQL Server 2008 or higher
In 2008 you can also look at
sys.dm_os_memory_nodes
sys.dm_os_memory_brokers
Regards
Patrick Flynn
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply