SQL Script:SQL memory configurationHere is some code to run if you're on SQL Server 2008 and 2008 R2 :

SELECT     [physical_memory_in_bytes] AS [PhysMemBytes],     [physical_memory_in_use_kb] AS [PhysMemInUseKB],     [available_physical_memory_kb] AS [PhysMemAvailKB],     [locked_page_allocations_kb] AS [LPAllocKB],     [max_server_memory] AS [MaxSvrMem],     [min_server_memory] AS [MinSvrMem] FROM     sys.dm_os_sys_info CROSS JOIN     sys.dm_os_process_memory CROSS JOIN     sys.dm_os_sys_memory CROSS JOIN (     SELECT         [value_in_use] AS [max_server_memory]     FROM         sys.configurations     WHERE         [name] = 'max server memory (MB)') AS c CROSS JOIN (     SELECT         [value_in_use] AS [min_server_memory]     FROM         sys.configurations     WHERE         [name] = 'min server memory (MB)') AS c2

On 2012, the code is :

SELECT     [physical_memory_kb] AS [PhysMemKB],     [physical_memory_in_use] AS [PhysMemInUseKB],     [available_physical_memory_kb] AS [PhysMemAvailKB],     [locked_page_allocations_kb] AS [LPAllocKB],     [max_server_memory] AS [MaxSvrMem],     [min_server_memory] AS [MinSvrMem] FROM     sys.dm_os_sys_info CROSS JOIN     sys.dm_os_process_memory CROSS JOIN     sys.dm_os_sys_memory CROSS JOIN (     SELECT         [value_in_use] AS [max_server_memory]     FROM         sys.configurations     WHERE         [name] = 'max server memory (MB)') AS c CROSS JOIN (     SELECT         [value_in_use] AS [min_server_memory]     FROM         sys.configurations     WHERE         [name] = 'min server memory (MB)') AS c2

And on 2005/2000, if you want to participate, send me the amount of memory on the Windows server, plus the min and max server memory configuration for SQL Server.