DIR Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
  HTML https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: Scripts
       *****************************************************
       #Post#: 132--------------------------------------------------
       Find Memory allocated to SQL Server 
       By: srinivasma_exceldbp Date: January 4, 2015, 11:21 pm
       ---------------------------------------------------------
       -- SQL 2008 and above
       -- To get the total physical memory installed on SQL Server
       SELECT [total_physical_memory_kb] / 1024 AS
       [Total_Physical_Memory_In_MB]
       ,[available_page_file_kb] / 1024 AS
       [Available_Physical_Memory_In_MB]
       ,[total_page_file_kb] / 1024 AS [Total_Page_File_In_MB]
       ,[available_page_file_kb] / 1024 AS [Available_Page_File_MB]
       ,[kernel_paged_pool_kb] / 1024 AS [Kernel_Paged_Pool_MB]
       ,[kernel_nonpaged_pool_kb] / 1024 AS
       [Kernel_Nonpaged_Pool_MB]
       ,[system_memory_state_desc] AS [System_Memory_State_Desc]
       FROM [master].[sys].[dm_os_sys_memory]
       
       --To get the minimum and maximum size of memory configured for
       SQL Server.
       SELECT [name] AS [Name]
       ,[configuration_id] AS [Number]
       ,[minimum] AS [Minimum]
       ,[maximum] AS [Maximum]
       ,[is_dynamic] AS [Dynamic]
       ,[is_advanced] AS [Advanced]
       ,[value] AS [ConfigValue]
       ,[value_in_use] AS [RunValue]
       ,[description] AS [Description]
       FROM [master].[sys].[configurations]
       WHERE NAME IN ('Min server memory (MB)', 'Max server memory
       (MB)')
       *****************************************************