Memory Manager KB ------------------------------ -------------------- VM Reserved 1805144 VM Committed 1737792 AWE Allocated 0 Reserved Memory 1024 Reserved Memory In Use 0 (5 row(s) affected) Memory node Id = 0 KB ------------------------------ -------------------- VM Reserved 1800984 VM Committed 1733784 AWE Allocated 0 MultiPage Allocator 23528 SinglePage Allocator 43624 (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 3640 MultiPage Allocator 3104 (7 row(s) affected) MEMORYCLERK_SQLBUFFERPOOL (Total) KB ---------------------------------------------------------------- -------------------- VM Reserved 1654624 VM Committed 1654624 AWE Allocated 0 SM Reserved 0 SM Commited 0 SinglePage Allocator 0 MultiPage Allocator 400 (7 row(s) affected) MEMORYCLERK_SQLQUERYEXEC (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_SQLOPTIMIZER (Total) KB ---------------------------------------------------------------- -------------------- VM Reserved 0 VM Committed 0 AWE Allocated 0 SM Reserved 0 SM Commited 0 SinglePage Allocator 2464 MultiPage Allocator 72 (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 592 MultiPage Allocator 0 (7 row(s) affected) MEMORYCLERK_SQLSTORENG (Total) KB ---------------------------------------------------------------- -------------------- VM Reserved 8064 VM Committed 8064 AWE Allocated 0 SM Reserved 0 SM Commited 0 SinglePage Allocator 4928 MultiPage Allocator 512 (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 616 MultiPage Allocator 0 (7 row(s) affected) MEMORYCLERK_SQLCLR (Total) KB ---------------------------------------------------------------- -------------------- VM Reserved 102464 VM Committed 36208 AWE Allocated 0 SM Reserved 0 SM Commited 0 SinglePage Allocator 1024 MultiPage Allocator 5232 (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 192 (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 96 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 72 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 96 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 24 MultiPage Allocator 0 (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 14200 MultiPage Allocator 13760 (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 24 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 8 MultiPage Allocator 0 (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 56 MultiPage Allocator 0 (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 8 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 16 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 16 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 408 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 8 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 32 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 592 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 6928 MultiPage Allocator 48 (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 1392 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 304 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 3072 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 8 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 0 (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 1128 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 256 MultiPage Allocator 0 (7 row(s) affected) OBJECTSTORE_LOCK_MANAGER (Total) KB ---------------------------------------------------------------- -------------------- VM Reserved 8192 VM Committed 8192 AWE Allocated 0 SM Reserved 0 SM Commited 0 SinglePage Allocator 1160 MultiPage Allocator 0 (7 row(s) affected) Buffer Distribution Buffers ------------------------------ ----------- Stolen 3509 Free 5971 Cached 1944 Database (clean) 191509 Database (dirty) 1867 I/O 0 Latched 0 (7 row(s) affected) Buffer Counts Buffers ------------------------------ -------------------- Committed 204800 Target 204800 Hashed 193376 Stolen Potential 189107 External Reservation 0 Min Free 128 Visible 204800 Available Paging File 271475 (8 row(s) affected) Procedure Cache Value ------------------------------ ----------- TotalProcs 0 TotalPages 11 InUsePages 0 (3 row(s) affected) Global Memory Objects Buffers ------------------------------ -------------------- Resource 472 Locks 148 XDES 39 SETLS 4 SE Dataset Allocators 8 SubpDesc Allocators 4 SE SchemaManager 871 SQLCache 50 Replication 2 ServerGlobal 26 XP Global 2 SortTables 2 (12 row(s) affected) Query Memory Objects Value ------------------------------ ----------- Grants 0 Waiting 0 Available (Buffers) 146205 Maximum (Buffers) 146205 Limit 146205 Next Request 0 Waiting For 0 Cost 0 Timeout 0 Wait Time 0 Last Target 153900 (11 row(s) affected) Small Query Memory Objects Value ------------------------------ ----------- Grants 0 Waiting 0 Available (Buffers) 7695 Maximum (Buffers) 7695 Limit 7695 (5 row(s) affected) Optimization Queue Value ------------------------------ -------------------- Overall Memory 1344798720 Target Memory 1289166848 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 250000 Threshold 250000 (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 1945 Rate -1305 Target Allocations 154528 Future Allocations 0 Last Notification 1 (5 row(s) affected) MEMORYBROKER_FOR_STEAL Value -------------------------------- -------------------- Allocations 3502 Rate -21 Target Allocations 157369 Future Allocations 0 Last Notification 1 (5 row(s) affected) MEMORYBROKER_FOR_RESERVE Value -------------------------------- -------------------- Allocations 0 Rate -354 Target Allocations 164160 Future Allocations 36551 Last Notification 1 (5 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator.