[SQL Server] Afficher la synthèse d'utilisation de la RAM
-- Informations sur l'utilisation de la mémoire par SQL Server
SELECT
(total_physical_memory_kb / 1024)/ 1024 AS Total_Memory_GB,
(available_physical_memory_kb / 1024)/ 1024 AS Available_Memory_GB,
((total_physical_memory_kb - available_physical_memory_kb) / 1024)/ 1024 AS Used_Memory_GB,
((CAST(total_physical_memory_kb - available_physical_memory_kb AS FLOAT) / total_physical_memory_kb) * 100) AS Used_Memory_Percentage,
((CAST(available_physical_memory_kb AS FLOAT) / total_physical_memory_kb) * 100) AS Free_Memory_Percentage
FROM sys.dm_os_sys_memory;