Created
June 8, 2020 16:42
-
-
Save diffie303/3599a7b329604855f406a7e32888aa7f to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Process/System Counts Value | |
------------------------------------------------------------------------ -------------------- | |
Available Physical Memory 26190585856 | |
Available Virtual Memory 140668500267008 | |
Available Paging File 31710347264 | |
Working Set 170340352 | |
Percent of Committed Memory in WS 100 | |
Page Faults 139155 | |
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 66773016 | |
VM Committed 387272 | |
Locked Pages Allocated 7099344 | |
Large Pages Allocated 264192 | |
Emergency Memory 1024 | |
Emergency Memory In Use 16 | |
Target Committed 31104568 | |
Current Committed 7486616 | |
Pages Allocated 6657384 | |
Pages Reserved 691160 | |
Pages Free 262872 | |
Pages In Use 3198488 | |
Page Alloc Potential 26685928 | |
NUMA Growth Phase 0 | |
Last OOM Factor 0 | |
Last OS Error 0 | |
(16 rows affected) | |
Memory node Id = 0 KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 66740056 | |
VM Committed 354432 | |
Locked Pages Allocated 7099344 | |
Pages Allocated 6657384 | |
Pages Free 262872 | |
Target Committed 31071720 | |
Current Committed 7453776 | |
Foreign Committed 0 | |
Away Committed 0 | |
Taken Away Committed 0 | |
(10 rows affected) | |
Memory node Id = 1 KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 32768 | |
VM Committed 32804 | |
Locked Pages Allocated 0 | |
Pages Allocated 0 | |
Pages Free 0 | |
Target Committed 32808 | |
Current Committed 32808 | |
Foreign Committed 0 | |
Away Committed 0 | |
Taken Away Committed 0 | |
(10 rows affected) | |
Memory node Id = 64 KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 36 | |
Locked Pages Allocated 0 | |
(3 rows affected) | |
MEMORYCLERK_XE_BUFFER (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 8448 | |
VM Committed 8448 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 0 | |
(6 rows affected) | |
MEMORYCLERK_XE_BUFFER (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 4224 | |
VM Committed 4224 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 0 | |
(6 rows affected) | |
MEMORYCLERK_XE_BUFFER (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 12672 | |
VM Committed 12672 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 0 | |
(6 rows affected) | |
MEMORYCLERK_HOST (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 248 | |
(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 47360 | |
(6 rows affected) | |
MEMORYCLERK_SOSNODE (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 11568 | |
(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 3024 | |
(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 61952 | |
(6 rows affected) | |
MEMORYCLERK_SOSOS (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 36 | |
VM Committed 36 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 1440 | |
(6 rows affected) | |
MEMORYCLERK_SOSMEMMANAGER (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 98752 | |
VM Committed 96192 | |
Locked Pages Allocated 2472 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 0 | |
(6 rows affected) | |
MEMORYCLERK_BITMAP (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 2097152 | |
VM Committed 484 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 0 | |
(6 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 23056 | |
(6 rows affected) | |
MEMORYCLERK_SQLGENERAL (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 192 | |
(6 rows affected) | |
MEMORYCLERK_SQLGENERAL (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 23248 | |
(6 rows affected) | |
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 29286108 | |
VM Committed 75776 | |
Locked Pages Allocated 115752 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 4716352 | |
(6 rows affected) | |
MEMORYCLERK_SQLQUERYPLAN (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 1816 | |
(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 18968 | |
(6 rows affected) | |
MEMORYCLERK_SQLQUERYEXEC (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 31752 | |
(6 rows affected) | |
MEMORYCLERK_SQLQUERYEXEC (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 50720 | |
(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 1296 | |
(6 rows affected) | |
MEMORYCLERK_QUERYDISKSTORE (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) | |
MEMORYCLERK_QUERYDISKSTORE_STATS (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) | |
MEMORYCLERK_SQLUTILITIES (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 520 | |
(6 rows affected) | |
MEMORYCLERK_SQLSTORENG (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 60864 | |
VM Committed 0 | |
Locked Pages Allocated 60864 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 108744 | |
(6 rows affected) | |
MEMORYCLERK_SQLSTORENG (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 10088 | |
(6 rows affected) | |
MEMORYCLERK_SQLSTORENG (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 60864 | |
VM Committed 0 | |
Locked Pages Allocated 60864 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 118832 | |
(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 3008 | |
(6 rows affected) | |
MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 2696 | |
(6 rows affected) | |
MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 5704 | |
(6 rows affected) | |
MEMORYCLERK_SQLCLR (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 3545728 | |
VM Committed 4156 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 24928 | |
(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 2112 | |
(6 rows affected) | |
MEMORYCLERK_SQLSERVICEBROKER (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 16 | |
(6 rows affected) | |
MEMORYCLERK_SQLSERVICEBROKER (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 2128 | |
(6 rows affected) | |
MEMORYCLERK_SQLHTTP (node 1) 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 88 | |
(6 rows affected) | |
MEMORYCLERK_SNI (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 128 | |
(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 232 | |
(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 16 | |
(6 rows affected) | |
MEMORYCLERK_BHF (node 1) 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 (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 32 | |
(6 rows affected) | |
MEMORYCLERK_SQLQERESERVATIONS (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 275032 | |
(6 rows affected) | |
MEMORYCLERK_SQLQERESERVATIONS (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 547448 | |
(6 rows affected) | |
MEMORYCLERK_SQLQERESERVATIONS (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 822480 | |
(6 rows affected) | |
MEMORYCLERK_SQLTRACE (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 2232 | |
(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 2720 | |
(6 rows affected) | |
MEMORYCLERK_CSILOBCOMPRESSION (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 72 | |
(6 rows affected) | |
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 216 | |
SM Committed 216 | |
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 328 | |
(6 rows affected) | |
MEMORYCLERK_FSAGENT (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 24 | |
(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 72 | |
(6 rows affected) | |
MEMORYCLERK_SPATIAL (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_HADR (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 40 | |
(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 12000 | |
(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 72 | |
(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 56 | |
(6 rows affected) | |
MEMORYCLERK_SVL (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_SLOG (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 448 | |
(6 rows affected) | |
MEMORYCLERK_SLOG (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 32 | |
(6 rows affected) | |
MEMORYCLERK_SLOG (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 480 | |
(6 rows affected) | |
MEMORYCLERK_QUERYPROFILE (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 11448 | |
(6 rows affected) | |
MEMORYCLERK_POLYBASE (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 1) 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 24 | |
(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 94872 | |
(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 524312 | |
(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 532968 | |
(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 112 | |
(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 112 | |
(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_BROKERTBLACS (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) | |
CACHESTORE_BROKERTBLACS (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 120 | |
(6 rows affected) | |
CACHESTORE_BROKERTBLACS (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 296 | |
(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_SEHOBTCOLUMNATTRIBUTE (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 968 | |
(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 41016 | |
(6 rows affected) | |
CACHESTORE_SYSTEMROWSET (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 4136 | |
(6 rows affected) | |
CACHESTORE_SYSTEMROWSET (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 45152 | |
(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 64 | |
(6 rows affected) | |
CACHESTORE_CONVPRI (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 16 | |
(6 rows affected) | |
CACHESTORE_CONVPRI (Total) 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 72 | |
(6 rows affected) | |
CACHESTORE_QDSRUNTIMESTATS (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_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 35912 | |
(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 159600 | |
(6 rows affected) | |
USERSTORE_DBMETADATA (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 11104 | |
(6 rows affected) | |
USERSTORE_DBMETADATA (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 170704 | |
(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 21968 | |
(6 rows affected) | |
USERSTORE_TOKENPERM (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 4112 | |
(6 rows affected) | |
USERSTORE_TOKENPERM (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 26080 | |
(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 15912 | |
(6 rows affected) | |
USERSTORE_OBJPERM (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 360 | |
(6 rows affected) | |
USERSTORE_OBJPERM (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 16272 | |
(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 104 | |
(6 rows affected) | |
USERSTORE_SXC (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 168 | |
(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 280 | |
(6 rows affected) | |
USERSTORE_QDSSTMT (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 880 | |
(6 rows affected) | |
USERSTORE_QDSSTMT (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 32 | |
(6 rows affected) | |
USERSTORE_QDSSTMT (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 912 | |
(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 224 | |
(6 rows affected) | |
OBJECTSTORE_LBSS (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 176 | |
(6 rows affected) | |
OBJECTSTORE_LBSS (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 400 | |
(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 1440 | |
(6 rows affected) | |
OBJECTSTORE_SNI_PACKET (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 1704 | |
(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 64 | |
(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 3208 | |
(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 432 | |
(6 rows affected) | |
OBJECTSTORE_SERVICE_BROKER (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 128 | |
(6 rows affected) | |
OBJECTSTORE_SERVICE_BROKER (Total) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 560 | |
(6 rows affected) | |
OBJECTSTORE_LOCK_MANAGER (node 0) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 131072 | |
VM Committed 131072 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 14448 | |
(6 rows affected) | |
OBJECTSTORE_LOCK_MANAGER (node 1) KB | |
------------------------------------------------------------------------ ----------- | |
VM Reserved 0 | |
VM Committed 0 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 12272 | |
(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 131072 | |
VM Committed 131072 | |
Locked Pages Allocated 0 | |
SM Reserved 0 | |
SM Committed 0 | |
Pages Allocated 26744 | |
(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 2992 | |
(6 rows affected) | |
Buffer Pool Pages | |
------------------------------------------------------------------------ ----------- | |
Database 589543 | |
Simulated 0 | |
Target 73695232 | |
Dirty 103505 | |
In IO 0 | |
Latched 7 | |
IO error 12590 | |
Page Life Expectancy 5936 | |
(8 rows affected) | |
Buffer Pool Current Clock Stats Count | |
------------------------------------------------------------------------ ----------- | |
Never Used 0 | |
Stolen or Free 0 | |
Above Cutoff 0 | |
Not on LRU 0 | |
Single Use 0 | |
Long IO Queue 0 | |
In IO 0 | |
In Allocation 0 | |
Preemptive 0 | |
Skip Pool 0 | |
Moved to L2 0 | |
Evicted 0 | |
Evicted Mapped 0 | |
(13 rows affected) | |
Buffer Pool Previous Clock Stats Count | |
------------------------------------------------------------------------ ----------- | |
Never Used 0 | |
Stolen or Free 0 | |
Above Cutoff 0 | |
Not on LRU 0 | |
Single Use 0 | |
Long IO Queue 0 | |
In IO 0 | |
In Allocation 0 | |
Preemptive 0 | |
Skip Pool 0 | |
Moved to L2 0 | |
Evicted 0 | |
Evicted Mapped 0 | |
(13 rows affected) | |
Procedure Cache Value | |
------------------------------------------------------------------------ ----------- | |
TotalProcs 7028 | |
TotalPages 144033 | |
InUsePages 1074 | |
(3 rows affected) | |
Global Memory Objects Pages | |
------------------------------------------------------------------------ ----------- | |
Resource 1048 | |
Locks 3343 | |
XDES 221 | |
DirtyPageTracking 339 | |
SETLS 9 | |
SubpDesc Allocators 9 | |
SE SchemaManager 2690 | |
SE Column Metadata Cache 1798 | |
SE Column Metadata Cache Store 14 | |
SQLCache 356 | |
Replication 2 | |
ServerGlobal 1278 | |
XP Global 2 | |
SortTables 3 | |
(14 rows affected) | |
Query Memory Objects (internal) Value | |
------------------------------------------------------------------------ ----------- | |
Grants 0 | |
Waiting 0 | |
Available 2439574 | |
Current Max 2439574 | |
Future Max 2439574 | |
Physical Max 2845969 | |
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 75776 | |
Current Max 75776 | |
Future Max 75776 | |
(5 rows affected) | |
Query Memory Objects (default) Value | |
------------------------------------------------------------------------ ----------- | |
Grants 6 | |
Waiting 0 | |
Available 2743159 | |
Current Max 2845969 | |
Future Max 2845969 | |
Physical Max 2845969 | |
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 75776 | |
Current Max 75776 | |
Future Max 75776 | |
(5 rows affected) | |
Optimization Queue (internal) Value | |
------------------------------------------------------------------------ -------------------- | |
Overall Memory 25530621952 | |
Target Memory 22223994880 | |
Last Notification 1 | |
Timeout 6 | |
Early Termination Factor 5 | |
(5 rows affected) | |
Small Gateway (internal) Value | |
------------------------------------------------------------------------ ----------- | |
Configured Units 36 | |
Available Units 36 | |
Acquires 0 | |
Waiters 0 | |
Threshold Factor 380000 | |
Threshold 380000 | |
(6 rows affected) | |
Medium Gateway (internal) Value | |
------------------------------------------------------------------------ ----------- | |
Configured Units 9 | |
Available Units 9 | |
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 25530621952 | |
Target Memory 22067167232 | |
Last Notification 1 | |
Timeout 6 | |
Early Termination Factor 5 | |
(5 rows affected) | |
Small Gateway (default) Value | |
------------------------------------------------------------------------ ----------- | |
Configured Units 36 | |
Available Units 36 | |
Acquires 0 | |
Waiters 0 | |
Threshold Factor 380000 | |
Threshold 380000 | |
(6 rows affected) | |
Medium Gateway (default) Value | |
------------------------------------------------------------------------ ----------- | |
Configured Units 9 | |
Available Units 9 | |
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 KB | |
------------------------------------------------------------------------ ----------- | |
Reserved Current 822480 | |
Reserved Limit 27169320 | |
(2 rows affected) | |
Memory Pool (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 1016968 | |
Predicted 1017496 | |
Private Target 0 | |
Private Limit 0 | |
Total Target 29549336 | |
Total Limit 29549336 | |
OOM Count 0 | |
(7 rows affected) | |
MEMORYBROKER_FOR_CACHE (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 209688 | |
Rate 0 | |
Target Allocations 21674064 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_STEAL (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 238720 | |
Rate 24 | |
Target Allocations 21703120 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_RESERVE (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 0 | |
Rate 0 | |
Target Allocations 21464376 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_COMMITTED (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 566360 | |
Rate 504 | |
Target Allocations 22031240 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 0 | |
Rate 0 | |
Target Allocations 21464376 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_XTP (internal) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 2200 | |
Rate 0 | |
Target Allocations 21466576 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
Memory Pool (default) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 2229616 | |
Predicted 7067464 | |
Private Target 0 | |
Private Limit 0 | |
Total Target 29549336 | |
Total Limit 29549336 | |
OOM Count 0 | |
(7 rows affected) | |
MEMORYBROKER_FOR_CACHE (default) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 1289104 | |
Rate -104 | |
Target Allocations 22753480 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_STEAL (default) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 73112 | |
Rate 12480 | |
Target Allocations 21549968 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_RESERVE (default) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 866568 | |
Rate 234560 | |
Target Allocations 24932248 | |
Future Allocations 5691936 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_HASHED_DATA_PAGES (default) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 0 | |
Rate 0 | |
Target Allocations 21464376 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
MEMORYBROKER_FOR_XTP (default) KB | |
------------------------------------------------------------------------ ----------- | |
Allocations 832 | |
Rate 0 | |
Target Allocations 21465208 | |
Future Allocations 0 | |
Overall 24932248 | |
Last Notification 1 | |
(6 rows affected) | |
Memory Broker Clerk (Buffer Pool) Pages | |
------------------------------------------------------------------------ ---------------------- | |
Total 589543 | |
Simulated 0 | |
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. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment