11/18/2020 15:10:48,spid51,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 128
Process virtual memory low 0
Process physical memory low 0
System physical memory low 0
System physical memory high 1
Page Faults 266793
Percent of Committed Memory in WS 100
Working Set 417681408
Available Paging File 9115652096
Available Virtual Memory 140676394356736
Available Physical Memory 3446849536
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Process/System Counts Value
Last OS Error 0
Last OOM Factor 3
NUMA Growth Phase 0
Page Alloc Potential 27861016
Pages In Use 3667032
Pages Free 77384
Pages Reserved 669696
Pages Allocated 24914752
Current Committed 25893208
Target Committed 27412384
Emergency Memory In Use 16
Emergency Memory 1024
Large Pages Allocated 0
Locked Pages Allocated 25564036
VM Committed 329172
VM Reserved 54873108
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Memory Manager KB
Taken Away Committed 0
Away Committed 0
Foreign Committed 0
Current Committed 25893176
Target Committed 27411320
Pages Free 77472
Pages Allocated 24914664
Locked Pages Allocated 25564036
VM Committed 329136
VM Reserved 54872980
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Memory node Id = 0 KB
Locked Pages Allocated 0
VM Committed 36
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Memory node Id = 64 KB
Pages Allocated 0
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 12672
VM Reserved 12672
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_XE_BUFFER (node 0) KB
Pages Allocated 48
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_HOST (node 0) KB
Pages Allocated 98168
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SOSNODE (node 0) KB
Pages Allocated 3080
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SOSNODE (node 64) KB
Pages Allocated 101248
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SOSNODE (Total) KB
Pages Allocated 1432
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 32
VM Reserved 32
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SOSOS (node 0) KB
Pages Allocated 0
SM Committed 0
SM Reserved 0
Locked Pages Allocated 8520
VM Committed 100932
VM Reserved 208688
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SOSMEMMANAGER (node 0) KB
Pages Allocated 0
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 512
VM Reserved 2097152
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_BITMAP (node 0) KB
Pages Allocated 22416
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLGENERAL (node 0) KB
Pages Allocated 22821672
SM Committed 0
SM Reserved 0
Locked Pages Allocated 546740
VM Committed 75776
VM Reserved 12867644
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
Pages Allocated 3400
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQUERYPLAN (node 0) KB
Pages Allocated 3632
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0) KB
Pages Allocated 1128
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLOPTIMIZER (node 0) KB
Pages Allocated 6512
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_QUERYDISKSTORE (node 0) KB
Pages Allocated 168920
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_QUERYDISKSTORE_HASHMAP (node 0) KB
Pages Allocated 488
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_QUERYDISKSTORE_STATS (node 0) KB
Pages Allocated 80
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLUTILITIES (node 0) KB
Pages Allocated 25928
SM Committed 0
SM Reserved 0
Locked Pages Allocated 16640
VM Committed 0
VM Reserved 16640
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLSTORENG (node 0) KB
Pages Allocated 4392
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
Pages Allocated 22296
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 6888
VM Reserved 6300864
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLCLR (node 0) KB
Pages Allocated 448
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLHTTP (node 0) KB
Pages Allocated 176
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SNI (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SNI (node 64) KB
Pages Allocated 192
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SNI (Total) KB
Pages Allocated 296
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_FULLTEXT (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLXP (node 0) KB
Pages Allocated 88
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_QSRANGEPREFETCH (node 0) KB
Pages Allocated 440
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_BHF (node 0) KB
Pages Allocated 772680
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQERESERVATIONS (node 0) KB
Pages Allocated 10424
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLTRACE (node 0) KB
Pages Allocated 2256
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_XTP (node 0) KB
Pages Allocated 64
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_CSILOBCOMPRESSION (node 0) KB
Pages Allocated 0
SM Committed 192
SM Reserved 192
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
Pages Allocated 312
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_FSAGENT (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_FILETABLE (node 0) KB
Pages Allocated 128
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SPATIAL (node 0) KB
Pages Allocated 40
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_HADR (node 0) KB
Pages Allocated 23048
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLLOGPOOL (node 0) KB
Pages Allocated 64
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_LWC (node 0) KB
Pages Allocated 48
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_FSCHUNKER (node 0) KB
Pages Allocated 144
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLEXTENSIBILITY (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SVL (node 0) KB
Pages Allocated 56
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SLOG (node 0) KB
Pages Allocated 17888
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_QUERYPROFILE (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_STACKFRAMES (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_STACKFRAMES (node 64) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_STACKFRAMES (Total) KB
Pages Allocated 112104
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_OBJCP (node 0) KB
Pages Allocated 963064
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_SQLCP (node 0) KB
Pages Allocated 43920
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_PHDR (node 0) KB
Pages Allocated 152
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_XPROC (node 0) KB
Pages Allocated 144
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_TEMPTABLES (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_NOTIF (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_VIEWDEFINITIONS (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_XMLDBTYPE (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_XMLDBELEMENT (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_XMLDBATTRIBUTE (node 0) KB
Pages Allocated 216
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERTBLACS (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERKEK (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERDSH (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERRSB (node 0) KB
Pages Allocated 80
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERREADONLY (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_BROKERTO (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_EVENTS (node 0) KB
Pages Allocated 232
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
Pages Allocated 10808
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_SYSTEMROWSET (node 0) KB
Pages Allocated 48
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_CONVPRI (node 0) KB
Pages Allocated 32
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
Pages Allocated 64
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_QDSCONTEXTSETTINGS (node 0) KB
Pages Allocated 6192
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_QDSRUNTIMESTATS (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,CACHESTORE_XML_SELECTIVE_DG (node 0) KB
Pages Allocated 6368
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_SCHEMAMGR (node 0) KB
Pages Allocated 17592
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_DBMETADATA (node 0) KB
Pages Allocated 5648
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_TOKENPERM (node 0) KB
Pages Allocated 1280
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_OBJPERM (node 0) KB
Pages Allocated 528
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_SXC (node 0) KB
Pages Allocated 8
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_SXC (node 64) KB
Pages Allocated 536
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_SXC (Total) KB
Pages Allocated 72
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,USERSTORE_QDSSTMT (node 0) KB
Pages Allocated 448
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_LBSS (node 0) KB
Pages Allocated 3688
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_SNI_PACKET (node 0) KB
Pages Allocated 64
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_SNI_PACKET (node 64) KB
Pages Allocated 3752
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_SNI_PACKET (Total) KB
Pages Allocated 560
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_SERVICE_BROKER (node 0) KB
Pages Allocated 397256
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 131072
VM Reserved 131072
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB
Pages Allocated 24
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_LOCK_MANAGER (node 64) KB
Pages Allocated 397280
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 131072
VM Reserved 131072
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
Pages Allocated 528
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_XACT_CACHE (node 0) KB
Pages Allocated 16
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_XACT_CACHE (node 64) KB
Pages Allocated 544
SM Committed 0
SM Reserved 0
Locked Pages Allocated 0
VM Committed 0
VM Reserved 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,OBJECTSTORE_XACT_CACHE (Total) KB
Page Life Expectancy 161
IO error 0
Latched 10
In IO 33
Dirty 21418
Target 64782336
Simulated 69134
Database 2854981
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Buffer Pool Pages
Evicted Mapped 0
Evicted 10714
Moved to L2 0
Skip Pool 771815
Preemptive 0
In Allocation 0
In IO 0
Long IO Queue 0
Single Use 0
Not on LRU 0
Above Cutoff 1039574
Stolen or Free 5923
Never Used 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Buffer Pool Current Clock Stats Count
Evicted Mapped 0
Evicted 0
Moved to L2 0
Skip Pool 919346
Preemptive 0
In Allocation 0
In IO 0
Long IO Queue 0
Single Use 0
Not on LRU 0
Above Cutoff 1938948
Stolen or Free 13642
Never Used 3717
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Buffer Pool Previous Clock Stats Count
InUsePages 1115
TotalPages 139764
TotalProcs 6067
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Procedure Cache Value
SortTables 3
XP Global 2
ServerGlobal 1276
Replication 173
SQLCache 2831
SE Column Metadata Cache Store 7
SE Column Metadata Cache 366
SE SchemaManager 426
SubpDesc Allocators 11
SETLS 9
DirtyPageTracking 1413
XDES 137
Locks 49660
Resource 1075
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Global Memory Objects Pages
Wait Time 0
Timeout 0
Cost 0
Waiting For 0
Next Request 0
Physical Max 2501187
Future Max 2501187
Current Max 2501187
Available 2462904
Waiting 0
Grants 6
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Query Memory Objects (internal) Value
Future Max 73728
Current Max 73728
Available 73322
Waiting 0
Grants 2
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Small Query Memory Objects (internal) Value
Early Termination Factor 5
Timeout 6
Last Notification 1
Target Memory 18988769280
Overall Memory 22500073472
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Optimization Queue (internal) Value
Threshold 380000
Threshold Factor 380000
Waiters 0
Acquires 0
Available Units 32
Configured Units 32
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Small Gateway (internal) Value
Threshold -1
Threshold Factor 12
Waiters 0
Acquires 0
Available Units 8
Configured Units 8
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Medium Gateway (internal) Value
Threshold -1
Threshold Factor 8
Waiters 0
Acquires 0
Available Units 1
Configured Units 1
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Big Gateway (internal) Value
Reserved Limit 23152088
Reserved Current 309512
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Memory Pool Manager KB
OOM Count 0
Total Limit 26041760
Total Target 26041760
Private Limit 0
Private Target 0
Predicted 7892224
Allocations 3602304
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Memory Pool (internal) KB
Last Notification 1
Overall 21972728
Future Allocations 0
Target Allocations 19741976
Rate 168
Allocations 1592272
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYBROKER_FOR_CACHE (internal) KB
Last Notification 1
Overall 21972728
Future Allocations 0
Target Allocations 18543720
Rate 16
Allocations 394168
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYBROKER_FOR_STEAL (internal) KB
Last Notification 1
Overall 21972728
Future Allocations 5002368
Target Allocations 21972728
Rate 8504
Allocations 712632
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYBROKER_FOR_RESERVE (internal) KB
Last Notification 1
Overall 21972728
Future Allocations 0
Target Allocations 19050352
Rate 0
Allocations 900816
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYBROKER_FOR_COMMITTED (internal) KB
Last Notification 1
Overall 21972728
Future Allocations 0
Target Allocations 18149536
Rate 0
Allocations 0
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
Last Notification 1
Overall 21972728
Future Allocations 0
Target Allocations 18151952
Rate 0
Allocations 2416
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,MEMORYBROKER_FOR_XTP (internal) KB
Internal Freed 0
Periodic Freed 0
Value Of Memory 0
External Benefit 0
Internal Benefit 0
Simulation Benefit 0
Simulated 69134
Total 2854981
---------------------------------------- ----------
11/18/2020 15:10:48,spid51,Unknown,Memory Broker Clerk (Buffer Pool) Pages
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
Index Id 0
XTP Object Id -501
Object Id 0
Database Id 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (29 VARHEAP Lookaside heap)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
Index Id 0
XTP Object Id -501
Object Id 0
Database Id 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (28 PGPOOL 256K page pool)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
Index Id 0
XTP Object Id -501
Object Id 0
Database Id 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (27 PGPOOL 4K page pool)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 2591
Used (KB) 411
Allocated (KB) 448
Index Id 0
XTP Object Id -501
Object Id 0
Database Id 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (26 VARHEAP System heap)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (25 LOOKASIDE Transaction list element)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (24 LOOKASIDE Delta tracker cursor)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (23 LOOKASIDE Transaction delta tracker)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (22 LOOKASIDE Creation Statement Id Map Entry)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (21 LOOKASIDE Creation Statement Id Map)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (20 LOOKASIDE Log IO proxy)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (19 LOOKASIDE Log IO completion)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (18 LOOKASIDE Sequence object insert row)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (17 LOOKASIDE Sequence object map entry)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (16 LOOKASIDE Sequence object values map)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (15 LOOKASIDE Redo transaction map entry)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (14 LOOKASIDE Transaction recent rows)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (13 LOOKASIDE Heap cursor)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (12 LOOKASIDE Range cursor)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (11 LOOKASIDE Hash cursor)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (10 LOOKASIDE Transaction dependent ring buffer)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (9 LOOKASIDE Transaction save-point set entry)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (8 LOOKASIDE Transaction FK validation sets)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (7 LOOKASIDE Transaction partially-inserted rows set)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (6 LOOKASIDE Transaction constraint set)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (5 LOOKASIDE Transaction save-point set)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (4 LOOKASIDE Transaction write set)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (3 LOOKASIDE Transaction scan set)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (2 LOOKASIDE Transaction read set)
11/18/2020 15:10:48,spid51,Unknown,[INFO]
Allocation Count 0
Used (KB) 0
Allocated (KB) 0
---------------------------------------- ----------
XTP_MEMORY_CONSUMER (1 LOOKASIDE Transaction)