SELECT name, value, value_in_use, [description]
FROM sys.configurations
WHERE name like '%server memory%'
ORDER BY name OPTION (RECOMPILE);
Select
physical_memory_kb /1204 as [Os Physical MB],
virtual_memory_kb/1204 as [Os Virt MB]
from sys.dm_os_sys_info Get Server Memory
- Details
- Kategorie: T-SQL