查看SQLServer占用内存

--查看SQLServer占用内存
IF CAST(SUBSTRING(@@VERSION,22,4) AS INT)<2008
	select cast(cntr_value/(1024.0) as DECIMAL(12,1)) AS SQLServerMemoryMB
	from master.sys.sysperfinfo AS s
	where counter_name='Total Server Memory (KB)'
ELSE
	SELECT CAST(physical_memory_in_use_kb/1024.0 AS DECIMAL(12,1)) AS SQLServerMemoryMB 
	FROM sys.dm_os_process_memory

参考：

为什么在Windows 任务管理器中不能显示SQL Server分配的全部内存

(msdn) sys.dm_os_process_memory

(msdn) 监视内存使用量

windows任务管理器中的工作设置内存,内存专用工作集,提交大小详解