NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > Performance Counters > Total Server Memory

Template Script: Performance Counters\Total Server Memory.sql

SELECT OBJECT_NAME, counter_name, instance_name, cntr_value, CAST(cntr_value * 1.0 / 1024 / 1024 AS NUMERIC(20,2)) AS MemoryGB
FROM sys.dm_os_performance_counters
WHERE OBJECT_NAME = 'SQLServer:Memory Manager'
AND counter_name = 'Total Server Memory (KB)'

Description for Template Script: Performance Counters\Total Server Memory.sql

Todo