[20180312]进程管理其中的SQL Server进程占用内存远远大于SQL server内部统计出来的内存...
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
Locked Pages Allocated 0
Pages Allocated 24728712
Pages Free 35552
Target Committed 25599976
Current Committed 25599976
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
(10 rows affected)
Memory node Id = 64 KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 20
Locked Pages Allocated 0
(3 rows affected)
MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 27480
(6 rows affected)
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 12954432
VM Committed 655624
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 20682112
(6 rows affected)
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4448
(6 rows affected)
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1368
(6 rows affected)
MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 176
(6 rows affected)
MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- -----------
VM Reserved 10048
VM Committed 10048
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 17200
(6 rows affected)
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2608
(6 rows affected)
MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- -----------
VM Reserved 6302848
VM Committed 17884
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12384
(6 rows affected)
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 656
(6 rows affected)
MEMORYCLERK_SQLHTTP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
MEMORYCLERK_SNI (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 144
(6 rows affected)
MEMORYCLERK_SNI (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_SNI (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160
(6 rows affected)
MEMORYCLERK_FULLTEXT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296
(6 rows affected)
MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_BHF (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 208
(6 rows affected)
MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- -----------
VM Reserved 4608
VM Committed 4608
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_XTP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_HOST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 472
(6 rows affected)
MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 55328
(6 rows affected)
MEMORYCLERK_SOSNODE (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2432
(6 rows affected)
MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 57760
(6 rows affected)
MEMORYCLERK_SOSOS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
(6 rows affected)
MEMORYCLERK_SOSMEMMANAGER (node 0) KB
---------------------------------------- -----------
VM Reserved 79224
VM Committed 79080
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 96
SM Committed 96
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
(6 rows affected)
MEMORYCLERK_FILETABLE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_XE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3880
(6 rows affected)
MEMORYCLERK_SQLLOGPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 15224
(6 rows affected)
MEMORYCLERK_LWC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
MEMORYCLERK_FSCHUNKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
(6 rows affected)
CACHESTORE_OBJCP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 203560
(6 rows affected)
CACHESTORE_SQLCP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3322304
(6 rows affected)
CACHESTORE_PHDR (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 96720
(6 rows affected)
CACHESTORE_XPROC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 208
(6 rows affected)
CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 136
(6 rows affected)
CACHESTORE_NOTIF (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_VIEWDEFINITIONS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 240
(6 rows affected)
CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
(6 rows affected)
CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_EVENTS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_CLRPROC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 104
(6 rows affected)
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
----------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2032
(6 rows affected)
CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4944
(6 rows affected)
CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
(6 rows affected)
CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
----------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
CACHESTORE_XML_SELECTIVE_DG (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
USERSTORE_SCHEMAMGR (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 58736
(6 rows affected)
USERSTORE_DBMETADATA (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 26616
(6 rows affected)
USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40240
(6 rows affected)
USERSTORE_OBJPERM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 936
(6 rows affected)
USERSTORE_SXC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 336
(6 rows affected)
USERSTORE_SXC (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
USERSTORE_SXC (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 344
(6 rows affected)
OBJECTSTORE_LBSS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 200
(6 rows affected)
OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4496
(6 rows affected)
OBJECTSTORE_SNI_PACKET (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
(6 rows affected)
OBJECTSTORE_SNI_PACKET (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4552
(6 rows affected)
OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 496
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- -----------
VM Reserved 65536
VM Committed 65536
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 95160
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- -----------
VM Reserved 65536
VM Committed 65536
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 95184
(6 rows affected)
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
(6 rows affected)
OBJECTSTORE_XACT_CACHE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12096
(6 rows affected)
OBJECTSTORE_XACT_CACHE (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
OBJECTSTORE_XACT_CACHE (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12112
(6 rows affected)
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
(3 rows affected)
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
---------------------------------------- -----------
Grants 0
Waiting 0
Available 65536
Current Max 65536
Future Max 65536
(5 rows affected)
Remote Query Memory Objects (internal) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 1185982
Current Max 1185982
(4 rows affected)
Query Memory Objects (default) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 2366024
Current Max 2366024
Future Max 2366024
Physical Max 2371964
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
(11 rows affected)
Small Query Memory Objects (default) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 65536
Current Max 65536
Future Max 65536
(5 rows affected)
Remote Query Memory Objects (default) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 1185982
Current Max 1185982
(4 rows affected)
Optimization Queue (internal) Value
---------------------------------------- --------------------
Overall Memory 21299200000
Target Memory 16476872704
Last Notification 1
Timeout 6
Early Termination Factor 5
(5 rows affected)
Small Gateway (internal) Value
---------------------------------------- -----------
Configured Units 16
Available Units 16
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
(6 rows affected)
Medium Gateway (internal) Value
---------------------------------------- -----------
Configured Units 4
Available Units 4
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
(6 rows affected)
Big Gateway (internal) Value
---------------------------------------- -----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
(6 rows affected)
Optimization Queue (default) Value
---------------------------------------- --------------------
Overall Memory 21299200000
Target Memory 16435019776
Last Notification 1
Timeout 6
Early Termination Factor 5
(5 rows affected)
Small Gateway (default) Value
---------------------------------------- -----------
Configured Units 16
Available Units 16
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
(6 rows affected)
Medium Gateway (default) Value
---------------------------------------- -----------
Configured Units 4
Available Units 4
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
(6 rows affected)
Big Gateway (default) Value
---------------------------------------- -----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
(6 rows affected)
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
(7 rows affected)
MEMORYBROKER_FOR_CACHE (internal) Pages
---------------------------------------- -----------
Allocations 4808
Rate 0
Target Allocations 2005494
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_STEAL (internal) Pages
---------------------------------------- -----------
Allocations 10651
Rate 0
Target Allocations 2011337
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_RESERVE (internal) Pages
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2000686
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_COMMITTED (internal) Pages
---------------------------------------- -----------
Allocations 104466
Rate 0
Target Allocations 2105152
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_XTP (internal) Pages
---------------------------------------- -----------
Allocations 2
Rate 0
Target Allocations 2000688
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
Memory Pool (default) Pages
---------------------------------------- -----------
Allocations 486395
Predicted 1079387
Private Target 0
Private Limit 0
Total Target 3200000
Total Limit 3200000
OOM Count 0
(7 rows affected)
MEMORYBROKER_FOR_CACHE (default) Pages
---------------------------------------- -----------
Allocations 480853
Rate 1
Target Allocations 2481540
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_STEAL (default) Pages
---------------------------------------- -----------
Allocations 5542
Rate -3
Target Allocations 2006228
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_RESERVE (default) Pages
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2593677
Future Allocations 592991
Overall 2600000
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_XTP (default) Pages
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2000686
Future Allocations 0
Overall 2600000
Last Notification 1
(6 rows affected)
Memory Broker Clerk (Buffer Pool) Pages
---------------------------------------- ----------------------
Total 2585121
Simulated 646255
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，如需转载请自行联系原作者