Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement