SQL Server Memory Checking

–==================================
–== MEMORY CHECKING ==
–==================================
select * from sys.dm_os_performance_counters where counter_name like ‘%Target Server Memory%’
GO
select * from sys.dm_os_performance_counters where counter_name like ‘%Total Server Memory (KB)%’
GO
select *, cntr_value/1024.00/1024.00 from master..SYSPERFINFO where counter_name like ‘%Target Server Memory%’
GO
DBCC MEMORYSTATUS
GO
select sum(awe_allocated_kb) / 1024 as [AWE allocated, Mb] from sys.dm_os_memory_clerks

Update me when site is updated

Leave a Reply

You must be logged in to post a comment.