[20180312]进程管理其中的SQL Server进程占用内存远远大于SQL server内部统计出来的内存...-白红宇

[20180312]进程管理其中的SQL Server进程占用内存远远大于SQL server内部统计出来的内存...

阅读量：5292 次

发布时间：2019-06-14

本文共 24500 字，大约阅读时间需要 81 分钟。

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.

posted on

2018-03-12 10:12 阅读(

...) 评论(

...)

转载于:https://www.cnblogs.com/Amaranthus/p/8547786.html

你可能感兴趣的文章

C# 获取系统时间及时间格式转换

查看>>

WCF、WebAPI、WCFREST、WebService之间的区别

查看>>

2018-2019-2-20175332-实验四《Android程序设计》实验报告

Sqli labs系列-less-4 这关好坑！！！

Win7中不能调试windows service

查看>>

T-SQL触发器，限制一次只能删除一条数据

查看>>

boost库使用：vs2013下boost::container::vector编译出错解决

查看>>

通过httplib2 探索的学习的最佳方式

Node.js 入门：Express + Mongoose 基础使用

查看>>