SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE '%SQLServer:Memory Manager%'
在客户库里面：
SQLServer:Memory Manager Connection Memory (KB) 1968
SQLServer:Memory Manager Granted Workspace Memory (KB) 268176
SQLServer:Memory Manager Lock Memory (KB) 25000
SQLServer:Memory Manager Lock Blocks Allocated 105576
SQLServer:Memory Manager Lock Owner Blocks Allocated 102565
SQLServer:Memory Manager Lock Blocks 4258
SQLServer:Memory Manager Lock Owner Blocks 7590
SQLServer:Memory Manager Maximum Workspace Memory (KB) 1743720
SQLServer:Memory Manager Memory Grants Outstanding 1
SQLServer:Memory Manager Memory Grants Pending 0
SQLServer:Memory Manager Optimizer Memory (KB) 13164944
SQLServer:Memory Manager SQL Cache Memory (KB) 1968
SQLServer:Memory Manager Target Server Memory (KB) 16384000
SQLServer:Memory Manager Total Server Memory (KB) 16384000
一共才16G内存
1、为什么Optimizer Memory (KB)占据13G？正常情况下Maximum Workspace Memory (KB)占据90%。
2、Optimizer Memory (KB)里面都存着什么东西？
------解决方案--------------------
Optimizer Memory (KB)
指定服务器正用于查询优化的动态内存总数。
http://technet.microsoft.com/zh-cn/library/ms190924