Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Memory Manager KB
- ---------------------------------------- -----------
- VM Reserved 3184048
- VM Committed 578300
- Locked Pages Allocated 0
- Reserved Memory 1024
- Reserved Memory In Use 0
- (5 row(s) affected)
- Memory node Id = 0 KB
- ---------------------------------------- -----------
- VM Reserved 3182960
- VM Committed 577272
- Locked Pages Allocated 0
- MultiPage Allocator 23480
- SinglePage Allocator 39512
- (5 row(s) affected)
- MEMORYCLERK_SQLGENERAL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 1168
- MultiPage Allocator 3864
- (7 row(s) affected)
- MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 3149824
- VM Committed 546048
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 0
- MultiPage Allocator 400
- (7 row(s) affected)
- MEMORYCLERK_SQLQUERYEXEC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SQLOPTIMIZER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 96
- MultiPage Allocator 896
- (7 row(s) affected)
- MEMORYCLERK_SQLUTILITIES (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 240
- VM Committed 240
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 96
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SQLSTORENG (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 768
- VM Committed 768
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 896
- MultiPage Allocator 3976
- (7 row(s) affected)
- MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 440
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SQLCLR (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 128
- MultiPage Allocator 544
- (7 row(s) affected)
- MEMORYCLERK_SQLHTTP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SNI (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 16
- (7 row(s) affected)
- MEMORYCLERK_FULLTEXT (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 24
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SQLXP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_XE_BUFFER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 4224
- VM Committed 4224
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 0
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_HOST (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_SOSNODE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 2384
- MultiPage Allocator 10912
- (7 row(s) affected)
- MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
- ---------------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 48
- MultiPage Allocator 0
- (7 row(s) affected)
- MEMORYCLERK_XE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 64
- MultiPage Allocator 816
- (7 row(s) affected)
- CACHESTORE_OBJCP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 616
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_SQLCP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 19568
- MultiPage Allocator 1752
- (7 row(s) affected)
- CACHESTORE_PHDR (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 136
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_XPROC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_TEMPTABLES (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_NOTIF (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_VIEWDEFINITIONS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_XMLDBTYPE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_XMLDBELEMENT (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_XMLDBATTRIBUTE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERTBLACS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 40
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERKEK (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERDSH (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERRSB (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERREADONLY (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 32
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_BROKERTO (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_EVENTS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 16
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_SYSTEMROWSET (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 600
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_CONVPRI (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 32
- MultiPage Allocator 0
- (7 row(s) affected)
- CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 32
- MultiPage Allocator 0
- (7 row(s) affected)
- USERSTORE_SCHEMAMGR (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 1992
- MultiPage Allocator 16
- (7 row(s) affected)
- USERSTORE_DBMETADATA (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 600
- MultiPage Allocator 0
- (7 row(s) affected)
- USERSTORE_TOKENPERM (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 224
- MultiPage Allocator 0
- (7 row(s) affected)
- USERSTORE_OBJPERM (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 168
- MultiPage Allocator 0
- (7 row(s) affected)
- USERSTORE_SXC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 24
- MultiPage Allocator 0
- (7 row(s) affected)
- OBJECTSTORE_LBSS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 32
- MultiPage Allocator 48
- (7 row(s) affected)
- OBJECTSTORE_SNI_PACKET (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 8344
- MultiPage Allocator 56
- (7 row(s) affected)
- OBJECTSTORE_SERVICE_BROKER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 424
- MultiPage Allocator 0
- (7 row(s) affected)
- OBJECTSTORE_LOCK_MANAGER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 2048
- VM Committed 2048
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- SinglePage Allocator 1072
- MultiPage Allocator 0
- (7 row(s) affected)
- Buffer Pool Value
- ---------------------------------------- -----------
- Committed 64000
- Target 128000
- Database 3488
- Dirty 71
- In IO 0
- Latched 0
- Free 55573
- Stolen 4939
- Reserved 0
- Visible 128000
- Stolen Potential 116661
- Limiting Factor 17
- Last OOM Factor 0
- Page Life Expectancy 1007
- (14 row(s) affected)
- Process/System Counts Value
- ---------------------------------------- --------------------
- Available Physical Memory 845840384
- Available Virtual Memory 8792597913600
- Available Paging File 3720708096
- Working Set 591941632
- Percent of Committed Memory in WS 99
- Page Faults 414020
- System physical memory high 1
- System physical memory low 0
- Process physical memory low 0
- Process virtual memory low 0
- (10 row(s) affected)
- Procedure Cache Value
- ---------------------------------------- -----------
- TotalProcs 3
- TotalPages 2761
- InUsePages 0
- (3 row(s) affected)
- Global Memory Objects Pages
- ---------------------------------------- -----------
- Resource 227
- Locks 134
- XDES 24
- SETLS 2
- SE Dataset Allocators 4
- SubpDesc Allocators 2
- SE SchemaManager 139
- SE Column Metadata Cache 111
- SQLCache 2661
- Replication 2
- ServerGlobal 50
- XP Global 2
- SortTables 2
- (13 row(s) affected)
- Query Memory Objects (internal) Value
- ---------------------------------------- -----------
- Grants 0
- Waiting 0
- Available 91371
- Current Max 91371
- Future Max 91371
- Physical Max 91371
- Next Request 0
- Waiting For 0
- Cost 0
- Timeout 0
- Wait Time 0
- (11 row(s) affected)
- Small Query Memory Objects (internal) Value
- ---------------------------------------- -----------
- Grants 0
- Waiting 0
- Available 4809
- Current Max 4809
- Future Max 4809
- (5 row(s) affected)
- Optimization Queue (internal) Value
- ---------------------------------------- -----------
- Overall Memory 840499200
- Target Memory 774152192
- Last Notification 1
- Timeout 6
- Early Termination Factor 5
- (5 row(s) affected)
- Small Gateway (internal) Value
- ---------------------------------------- -----------
- Configured Units 8
- Available Units 8
- Acquires 0
- Waiters 0
- Threshold Factor 380000
- Threshold 380000
- (6 row(s) affected)
- Medium Gateway (internal) Value
- ---------------------------------------- -----------
- Configured Units 2
- Available Units 2
- Acquires 0
- Waiters 0
- Threshold Factor 12
- Threshold -1
- (6 row(s) affected)
- Big Gateway (internal) Value
- ---------------------------------------- -----------
- Configured Units 1
- Available Units 1
- Acquires 0
- Waiters 0
- Threshold Factor 8
- Threshold -1
- (6 row(s) affected)
- Memory Pool Manager Pages
- ---------------------------------------- -----------
- Reserved Current 0
- Reserved Limit 116665
- (2 row(s) affected)
- Memory Pool (internal) Pages
- ---------------------------------------- -----------
- Allocations 4935
- Predicted 27777
- Private Target 0
- Private Limit 0
- Total Target 121600
- Total Limit 121600
- OOM Count 80
- (7 row(s) affected)
- MEMORYBROKER_FOR_CACHE (internal) Pages
- ---------------------------------------- -----------
- Allocations 4257
- Rate -2
- Target Allocations 98080
- Future Allocations 0
- Overall 102600
- Last Notification 1
- (6 row(s) affected)
- MEMORYBROKER_FOR_STEAL (internal) Pages
- ---------------------------------------- -----------
- Allocations 678
- Rate 0
- Target Allocations 94501
- Future Allocations 0
- Overall 102600
- Last Notification 1
- (6 row(s) affected)
- MEMORYBROKER_FOR_RESERVE (internal) Pages
- ---------------------------------------- -----------
- Allocations 0
- Rate 0
- Target Allocations 102600
- Future Allocations 22842
- Overall 102600
- Last Notification 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement