Search notes:

SQL Server - sys.dm_os_sys_memory

The sys.dm_os_sys_memory view returns one row only. 
select
   convert(decimal(10, 2), total_physical_memory_kb     / 1024.0 / 1024.0)     total_physical_memory_gb,
   convert(decimal(10, 2), available_physical_memory_kb / 1024.0 / 1024.0) available_physical_memory_gb,
   convert(decimal(10, 2), total_page_file_kb           / 1024.0 / 1024.0)     total_page_file_gb,
   convert(decimal(10, 2), available_page_file_kb       / 1024.0 / 1024.0) available_page_file_gb,
   convert(decimal(10, 2), system_cache_kb              / 1024.0 / 1024.0) system_cache_gb,
   convert(decimal(10, 2), kernel_paged_pool_kb         / 1024.0 / 1024.0)    kernel_paged_pool_gb,
   convert(decimal(10, 2), kernel_nonpaged_pool_kb      / 1024.0 / 1024.0) kernel_nonpaged_pool_kb,
   --
   system_high_memory_signal_state,
   system_low_memory_signal_state,
   system_memory_state_desc
from
   sys.dm_os_sys_memory;

See also

memory management

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759398035, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL-Server/administration/schemas/sys/objects/views/dm/os/sys/memory(52): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78