Memory Manager                  KB 
------------------------------ --------------------
VM Reserved                    33892280
VM Committed                   320456
AWE Allocated                  29044192
Reserved Memory                1024
Reserved Memory In Use         0

(5 row(s) affected)

Memory node Id = 0              KB 
------------------------------ --------------------
VM Reserved                    33886520
VM Committed                   314784
AWE Allocated                  29044192
MultiPage Allocator            27224
SinglePage Allocator           448352

(5 row(s) affected)

MEMORYCLERK_SQLGENERAL (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            4800
 MultiPage Allocator                                             8104

(7 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (Total)                                 KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     33603584
 VM Committed                                                    32768
 AWE Allocated                                                   29044192
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            0
 MultiPage Allocator                                             1288

(7 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            2848
 MultiPage Allocator                                             96

(7 row(s) affected)

MEMORYCLERK_SQLUTILITIES (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     120
 VM Committed                                                    120
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            480
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLSTORENG (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     87040
 VM Committed                                                    87040
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            7800
 MultiPage Allocator                                             1696

(7 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (Total)                             KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            1872
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLCLR (Total)                                        KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (Total)                              KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            216
 MultiPage Allocator                                             320

(7 row(s) affected)

MEMORYCLERK_SQLHTTP (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SNI (Total)                                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            200
 MultiPage Allocator                                             16

(7 row(s) affected)

MEMORYCLERK_FULLTEXT (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLXP (Total)                                         KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_BHF (Total)                                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            80
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_HOST (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            160
 MultiPage Allocator                                             160

(7 row(s) affected)

MEMORYCLERK_SOSNODE (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            9608
 MultiPage Allocator                                             14640

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)                     KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            48
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_OBJCP (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            22928
 MultiPage Allocator                                             80

(7 row(s) affected)

CACHESTORE_SQLCP (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            28640
 MultiPage Allocator                                             136

(7 row(s) affected)

CACHESTORE_PHDR (Total)                                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8912
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XPROC (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            64
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_TEMPTABLES (Total)                                     KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            48
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_NOTIF (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_VIEWDEFINITIONS (Total)                                KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XMLDBTYPE (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XMLDBELEMENT (Total)                                   KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XMLDBATTRIBUTE (Total)                                 KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_STACKFRAMES (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            0
 MultiPage Allocator                                             8

(7 row(s) affected)

CACHESTORE_BROKERTBLACS (Total)                                   KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            592
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_BROKERKEK (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_BROKERDSH (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_BROKERUSERCERTLOOKUP (Total)                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_BROKERRSB (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_BROKERREADONLY (Total)                                 KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            88
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_BROKERTO (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_EVENTS (Total)                                         KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_SYSTEMROWSET (Total)                                   KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            9800
 MultiPage Allocator                                             0

(7 row(s) affected)

USERSTORE_SCHEMAMGR (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            7464
 MultiPage Allocator                                             32

(7 row(s) affected)

USERSTORE_DBMETADATA (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            23544
 MultiPage Allocator                                             0

(7 row(s) affected)

USERSTORE_TOKENPERM (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            13672
 MultiPage Allocator                                             0

(7 row(s) affected)

USERSTORE_OBJPERM (Total)                                         KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            1608
 MultiPage Allocator                                             0

(7 row(s) affected)

USERSTORE_SXC (Total)                                             KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            296
 MultiPage Allocator                                             0

(7 row(s) affected)

OBJECTSTORE_LBSS (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            64
 MultiPage Allocator                                             416

(7 row(s) affected)

OBJECTSTORE_SNI_PACKET (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            6784
 MultiPage Allocator                                             48

(7 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (Total)                                KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            288
 MultiPage Allocator                                             0

(7 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     131072
 VM Committed                                                    131072
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            325864
 MultiPage Allocator                                             0

(7 row(s) affected)

Buffer Distribution            Buffers
------------------------------ -----------
Stolen                         2524
Free                           110
Cached                         53521
Database (clean)               3323957
Database (dirty)               191700
I/O                            0
Latched                        2

(7 row(s) affected)

Buffer Counts                  Buffers
------------------------------ --------------------
Committed                      3571814
Target                         3634419
Hashed                         3515659
Stolen Potential               3928419
External Reservation           0
Min Free                       128
Visible                        3634419
Available Paging File          3011799

(8 row(s) affected)

Procedure Cache                Value
------------------------------ -----------
TotalProcs                     605
TotalPages                     7595
InUsePages                     104

(3 row(s) affected)

 
Global Memory Objects          Buffers
------------------------------ --------------------
Resource                       916
Locks                          40736
XDES                           99
SETLS                          4
SE Dataset Allocators          8
SubpDesc Allocators            4
SE SchemaManager               936
SQLCache                       266
Replication                    2
ServerGlobal                   56
XP Global                      2
SortTables                     2

(12 row(s) affected)

 
Query Memory Objects           Value
------------------------------ -----------
Grants                         0
Waiting                        0
Available (Buffers)            2718310
Maximum (Buffers)              2718310
Limit                          2718310
Next Request                   0
Waiting For                    0
Cost                           0
Timeout                        0
Wait Time                      0
Last Target                    2731110

(11 row(s) affected)

Small Query Memory Objects     Value
------------------------------ -----------
Grants                         0
Waiting                        0
Available (Buffers)            12800
Maximum (Buffers)              12800
Limit                          12800

(5 row(s) affected)

Optimization Queue             Value
------------------------------ --------------------
Overall Memory                 23864868864
Target Memory                  22279004160
Last Notification              1
Timeout                        6
Early Termination Factor       5

(5 row(s) affected)

Small Gateway                  Value
------------------------------ --------------------
Configured Units               16
Available Units                16
Acquires                       0
Waiters                        0
Threshold Factor               380000
Threshold                      380000

(6 row(s) affected)

Medium Gateway                 Value
------------------------------ --------------------
Configured Units               4
Available Units                4
Acquires                       0
Waiters                        0
Threshold Factor               12

(5 row(s) affected)

Big Gateway                    Value
------------------------------ --------------------
Configured Units               1
Available Units                1
Acquires                       0
Waiters                        0
Threshold Factor               8

(5 row(s) affected)

MEMORYBROKER_FOR_CACHE           Value
-------------------------------- --------------------
Allocations                      53523
Rate                             0
Target Allocations               2770611
Future Allocations               0
Last Notification                1

(5 row(s) affected)

MEMORYBROKER_FOR_STEAL           Value
-------------------------------- --------------------
Allocations                      2517
Rate                             0
Target Allocations               2719605
Future Allocations               0
Last Notification                1

(5 row(s) affected)

MEMORYBROKER_FOR_RESERVE         Value
-------------------------------- --------------------
Allocations                      0
Rate                             0
Target Allocations               2913192
Future Allocations               679577
Last Notification                1

(5 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
