sql server 统计出来的内存，不管是这个，还是dbcc memorystatus，和进程管理器中内存差距很大，差不多有70G的差异。
具体原因不止，可能是内存泄漏，目前只能通过重启服务解决
Process/System Counts Value
---------------------------------------- --------------------
Available Physical Memory 5337628672
Available Virtual Memory 8723028054016
Available Paging File 9299374080
Working Set 26316115968
Percent of Committed Memory in WS 100
Page Faults 12218866
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0
(10 rows affected)
Memory Manager KB
---------------------------------------- -----------
VM Reserved 70668820
VM Committed 25599992
Locked Pages Allocated 0
Large Pages Allocated 0
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 25600000
Current Committed 25599992
Pages Allocated 24728712
Pages Reserved 0
Pages Free 35552
Pages In Use 4883440
Page Alloc Potential 19436560
NUMA Growth Phase 2
Last OOM Factor 0
Last OS Error 0
(16 rows affected)
Memory node Id = 0 KB
VM Reserved 70668756
VM Committed 25599972
Target Committed 25599976
Current Committed 25599976
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
Memory node Id = 64 KB
VM Reserved 0
VM Committed 20
(3 rows affected)
MEMORYCLERK_SQLGENERAL (node 0) KB
VM Committed 0
SM Reserved 0
SM Committed 0
Pages Allocated 27480
(6 rows affected)
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
VM Reserved 12954432
VM Committed 655624
Pages Allocated 20682112
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
Pages Allocated 4448
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
Pages Allocated 1368
MEMORYCLERK_SQLUTILITIES (node 0) KB
Pages Allocated 176
MEMORYCLERK_SQLSTORENG (node 0) KB
VM Reserved 10048
VM Committed 10048
Pages Allocated 17200
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
Pages Allocated 2608
MEMORYCLERK_SQLCLR (node 0) KB
VM Reserved 6302848
VM Committed 17884
Pages Allocated 12384
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
Pages Allocated 656
MEMORYCLERK_SQLHTTP (node 0) KB
Pages Allocated 8
MEMORYCLERK_SNI (node 0) KB
Pages Allocated 144
MEMORYCLERK_SNI (node 64) KB
Pages Allocated 16
MEMORYCLERK_SNI (Total) KB
Pages Allocated 160
MEMORYCLERK_FULLTEXT (node 0) KB
Pages Allocated 296
MEMORYCLERK_SQLXP (node 0) KB
MEMORYCLERK_BHF (node 0) KB
Pages Allocated 208
MEMORYCLERK_XE_BUFFER (node 0) KB
VM Reserved 4608
VM Committed 4608
Pages Allocated 0
MEMORYCLERK_XTP (node 0) KB
MEMORYCLERK_HOST (node 0) KB
Pages Allocated 472
MEMORYCLERK_SOSNODE (node 0) KB
Pages Allocated 55328
MEMORYCLERK_SOSNODE (node 64) KB
Pages Allocated 2432
MEMORYCLERK_SOSNODE (Total) KB
Pages Allocated 57760
MEMORYCLERK_SOSOS (node 0) KB
Pages Allocated 192
MEMORYCLERK_SOSMEMMANAGER (node 0) KB
VM Reserved 79224
VM Committed 79080
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
SM Reserved 96
SM Committed 96
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
MEMORYCLERK_FILETABLE (node 0) KB
MEMORYCLERK_XE (node 0) KB
Pages Allocated 3880
MEMORYCLERK_SQLLOGPOOL (node 0) KB
Pages Allocated 15224
MEMORYCLERK_LWC (node 0) KB
Pages Allocated 32
MEMORYCLERK_FSCHUNKER (node 0) KB
Pages Allocated 48
CACHESTORE_OBJCP (node 0) KB
Pages Allocated 203560
CACHESTORE_SQLCP (node 0) KB
Pages Allocated 3322304
CACHESTORE_PHDR (node 0) KB
Pages Allocated 96720
CACHESTORE_XPROC (node 0) KB
CACHESTORE_TEMPTABLES (node 0) KB
Pages Allocated 136
CACHESTORE_NOTIF (node 0) KB
CACHESTORE_VIEWDEFINITIONS (node 0) KB
CACHESTORE_XMLDBTYPE (node 0) KB
CACHESTORE_XMLDBELEMENT (node 0) KB
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
CACHESTORE_STACKFRAMES (node 0) KB
CACHESTORE_STACKFRAMES (node 64) KB
CACHESTORE_STACKFRAMES (Total) KB
CACHESTORE_BROKERTBLACS (node 0) KB
Pages Allocated 240
CACHESTORE_BROKERKEK (node 0) KB
CACHESTORE_BROKERDSH (node 0) KB
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
CACHESTORE_BROKERRSB (node 0) KB
CACHESTORE_BROKERREADONLY (node 0) KB
Pages Allocated 80
CACHESTORE_BROKERTO (node 0) KB
CACHESTORE_EVENTS (node 0) KB
CACHESTORE_CLRPROC (node 0) KB
Pages Allocated 104
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
----------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2032
CACHESTORE_SYSTEMROWSET (node 0) KB
Pages Allocated 4944
CACHESTORE_CONVPRI (node 0) KB
CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
Pages Allocated 32
CACHESTORE_XML_SELECTIVE_DG (node 0) KB
USERSTORE_SCHEMAMGR (node 0) KB
Pages Allocated 58736
USERSTORE_DBMETADATA (node 0) KB
Pages Allocated 26616
USERSTORE_TOKENPERM (node 0) KB
Pages Allocated 40240
USERSTORE_OBJPERM (node 0) KB
Pages Allocated 936
USERSTORE_SXC (node 0) KB
Pages Allocated 336
USERSTORE_SXC (node 64) KB
USERSTORE_SXC (Total) KB
Pages Allocated 344
OBJECTSTORE_LBSS (node 0) KB
Pages Allocated 200
OBJECTSTORE_SNI_PACKET (node 0) KB
Pages Allocated 4496
OBJECTSTORE_SNI_PACKET (node 64) KB
Pages Allocated 56
OBJECTSTORE_SNI_PACKET (Total) KB
Pages Allocated 4552
OBJECTSTORE_SERVICE_BROKER (node 0) KB
Pages Allocated 496
OBJECTSTORE_LOCK_MANAGER (node 0) KB
VM Reserved 65536
VM Committed 65536
Pages Allocated 95160
OBJECTSTORE_LOCK_MANAGER (node 64) KB
Pages Allocated 24
OBJECTSTORE_LOCK_MANAGER (Total) KB
Pages Allocated 95184
OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
OBJECTSTORE_XACT_CACHE (node 0) KB
Pages Allocated 12096
OBJECTSTORE_XACT_CACHE (node 64) KB
OBJECTSTORE_XACT_CACHE (Total) KB
Pages Allocated 12112
Buffer Pool Value
Database 2585121
Simulated 646255
Target 65273856
Dirty 4140
In IO 0
Latched 0
Page Life Expectancy 1144
(7 rows affected)
Procedure Cache Value
TotalProcs 28879
TotalPages 452849
InUsePages 1213
Global Memory Objects Pages
Resource 991
Locks 11898
XDES 175
DirtyPageTracking 4
SETLS 4
SubpDesc Allocators 4
SE SchemaManager 2894
SE Column Metadata Cache 4447
SE Column Metadata Cache Store 69
SQLCache 4930
Replication 264
ServerGlobal 53
XP Global 2
SortTables 3
(14 rows affected)
Query Memory Objects (internal) Value
Grants 0
Waiting 0
Available 1810094
Current Max 1810094
Future Max 1810094
Physical Max 2371964
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
(11 rows affected)
Small Query Memory Objects (internal) Value
Available 65536
Current Max 65536
Future Max 65536
(5 rows affected)
Remote Query Memory Objects (internal) Value
Available 1185982
Current Max 1185982
(4 rows affected)
Query Memory Objects (default) Value
Available 2366024
Current Max 2366024
Future Max 2366024
Small Query Memory Objects (default) Value
Remote Query Memory Objects (default) Value
Optimization Queue (internal) Value
Overall Memory 21299200000
Target Memory 16476872704
Last Notification 1
Timeout 6
Early Termination Factor 5
Small Gateway (internal) Value
Configured Units 16
Available Units 16
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
Medium Gateway (internal) Value
Configured Units 4
Available Units 4
Threshold Factor 12
Threshold -1
Big Gateway (internal) Value
Configured Units 1
Available Units 1
Threshold Factor 8
Optimization Queue (default) Value
Target Memory 16435019776
Small Gateway (default) Value
Medium Gateway (default) Value
Big Gateway (default) Value
Memory Pool Manager Pages
Reserved Current 0
Reserved Limit 2593678
(2 rows affected)
Memory Pool (internal) Pages
Allocations 119927
Predicted 119927
Private Target 0
Private Limit 0
Total Target 3200000
Total Limit 3200000
OOM Count 0
MEMORYBROKER_FOR_CACHE (internal) Pages
Allocations 4808
Rate 0
Target Allocations 2005494
Future Allocations 0
Overall 2600000
MEMORYBROKER_FOR_STEAL (internal) Pages
Allocations 10651
Target Allocations 2011337
MEMORYBROKER_FOR_RESERVE (internal) Pages
Allocations 0
Target Allocations 2000686
MEMORYBROKER_FOR_COMMITTED (internal) Pages
Allocations 104466
Target Allocations 2105152
MEMORYBROKER_FOR_XTP (internal) Pages
Allocations 2
Target Allocations 2000688
Memory Pool (default) Pages
Allocations 486395
Predicted 1079387
MEMORYBROKER_FOR_CACHE (default) Pages
Allocations 480853
Rate 1
Target Allocations 2481540
MEMORYBROKER_FOR_STEAL (default) Pages
Allocations 5542
Rate -3
Target Allocations 2006228
MEMORYBROKER_FOR_RESERVE (default) Pages
Target Allocations 2593677
Future Allocations 592991
MEMORYBROKER_FOR_XTP (default) Pages
Memory Broker Clerk (Buffer Pool) Pages
---------------------------------------- ----------------------
Total 2585121
Simulation Benefit 0
Internal Benefit 0
External Benefit 0
Value Of Memory 0
Periodic Freed 0
Internal Freed 0
(8 rows affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
本文转自 Fanr_Zh 博客园博客，原文链接：http://www.cnblogs.com/Amaranthus/p/8547786.html，如需转载请自行联系原作者