Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT object_name, cntr_value
- FROM sys.dm_os_performance_counters
- WHERE counter_name = 'Total Server Memory (KB)';
- SELECT object_name, cntr_value
- FROM sys.dm_os_performance_counters
- WHERE counter_name IN ('Total Server Memory (KB)', 'Target Server Memory (KB)');
- -- SQL Server 2012:
- SELECT physical_memory_kb FROM sys.dm_os_sys_info;
- -- Prior versions:
- SELECT physical_memory_in_bytes FROM sys.dm_os_sys_info;
- EXEC sp_configure 'max server memory';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement