June 18, 2010 at 5:53 am
Instance is running on a windows 2008 server with SP2
4 quad core processors and 64 GB Mry.
Currently running as only instance on this server with min 0 and max 4 GB mry
from time to time I see following errors in log.
2010-06-18 11:25:01.71 spid52 Failed allocate pages: FAIL_PAGE_ALLOCATION 1
2010-06-18 11:25:01.72 spid67 Error: 701, Severity: 17, State: 130.
2010-06-18 11:25:01.72 spid67 There is insufficient system memory to run this query.
2010-06-18 11:25:01.72 spid130 Error: 701, Severity: 17, State: 130.
2010-06-18 11:25:01.72 spid130 There is insufficient system memory to run this query.
2010-06-18 11:25:01.72 spid66 Error: 701, Severity: 17, State: 130.
2010-06-18 11:25:01.72 spid66 There is insufficient system memory to run this query.
2010-06-18 11:25:01.73 spid63 Error: 701, Severity: 17, State: 130.
2010-06-18 11:25:01.73 spid63 There is insufficient system memory to run this query.
2010-06-18 11:25:01.73 spid144 Error: 701, Severity: 17, State: 193.
2010-06-18 11:25:01.73 spid144 There is insufficient system memory to run this query.
There is a KB artikle about this
Article ID: 912439 - Last Review: April 6, 2006 - Revision: 2.3
With STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2005 Service Pack 1.
I'm running SP3 with CU8
Can some one tell me if this bug is still not fixxed or do I need to install an aditional bug fix for it?
Memory manager logging is
Memory Manager
VM Reserved = 73610720 KB
VM Committed = 4520160 KB
AWE Allocated = 0 KB
Reserved Memory = 1024 KB
Reserved Memory In Use = 0 KB 2010-06-18 11:25:01.76 spid52
Memory node Id = 0
VM Reserved = 73604960 KB
VM Committed = 4514488 KB
AWE Allocated = 0 KB
SinglePage Allocator = 4091144 KB
MultiPage Allocator = 73392 KB 2010-06-18 11:25:01.76 spid52
MEMORYCLERK_SQLGENERAL (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 7552 KB
MultiPage Allocator = 4568 KB 2010-06-18 11:25:01.76 spid52
MEMORYCLERK_SQLBUFFERPOOL (Total)
VM Reserved = 67190784 KB
VM Committed = 4326656 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 520 KB 2010-06-18 11:25:01.76 spid52
MEMORYCLERK_SQLQUERYEXEC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLOPTIMIZER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1592 KB
MultiPage Allocator = 128 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLUTILITIES (Total)
VM Reserved = 480 KB
VM Committed = 480 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 112 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLSTORENG (Total)
VM Reserved = 2944 KB
VM Committed = 2944 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5408 KB
MultiPage Allocator = 12832 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLCONNECTIONPOOL (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1592 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLCLR (Total)
VM Reserved = 6315904 KB
VM Committed = 93112 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2712 KB
MultiPage Allocator = 40312 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLSERVICEBROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 72 KB
MultiPage Allocator = 304 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLHTTP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SNI (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 168 KB
MultiPage Allocator = 16 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_FULLTEXT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLXP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid141 Error: 701, Severity: 17, State: 130.
2010-06-18 11:25:01.77 spid141 There is insufficient system memory to run this query.
2010-06-18 11:25:01.77 spid52
MEMORYCLERK_BHF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_HOST (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 24 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SOSNODE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 131952 KB
MultiPage Allocator = 14360 KB 2010-06-18 11:25:01.77 spid52
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 48 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid144 Error: 701, Severity: 17, State: 193.
2010-06-18 11:25:01.77 spid144 There is insufficient system memory to run this query.
2010-06-18 11:25:01.77 spid144 Error: 701, Severity: 17, State: 193.
2010-06-18 11:25:01.77 spid144 There is insufficient system memory to run this query.
2010-06-18 11:25:01.77 spid57 Error: 701, Severity: 17, State: 130.
2010-06-18 11:25:01.77 spid57 There is insufficient system memory to run this query.
2010-06-18 11:25:01.77 spid52
CACHESTORE_OBJCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_SQLCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 536 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_PHDR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid144 Error: 701, Severity: 17, State: 193.
2010-06-18 11:25:01.77 spid144 There is insufficient system memory to run this query.
2010-06-18 11:25:01.77 spid52
CACHESTORE_XPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_TEMPTABLES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 120 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_NOTIF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_VIEWDEFINITIONS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_XMLDBTYPE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_XMLDBELEMENT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_XMLDBATTRIBUTE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_STACKFRAMES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 8 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERTBLACS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 88 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERKEK (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERDSH (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERUSERCERTLOOKUP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERRSB (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERREADONLY (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_BROKERTO (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_EVENTS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_CLRPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
CACHESTORE_SYSTEMROWSET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 88 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
USERSTORE_SCHEMAMGR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16016 KB
MultiPage Allocator = 112 KB 2010-06-18 11:25:01.77 spid52
USERSTORE_DBMETADATA (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 984 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
USERSTORE_TOKENPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1584 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
USERSTORE_OBJPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1664 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
USERSTORE_SXC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 3909992 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
OBJECTSTORE_LBSS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 256 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
OBJECTSTORE_SNI_PACKET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2288 KB
MultiPage Allocator = 48 KB 2010-06-18 11:25:01.77 spid52
OBJECTSTORE_SERVICE_BROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 272 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52
OBJECTSTORE_LOCK_MANAGER (Total)
VM Reserved = 16384 KB
VM Committed = 16384 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5728 KB
MultiPage Allocator = 0 KB 2010-06-18 11:25:01.77 spid52 Buffer Distribution: Stolen=19128 Free=2142 Cached=492476
Database (clean)=10365 Database (dirty)=152
I/O=24, Latched=1 2010-06-18 11:25:01.77 spid52 Buffer Counts: Committed=524288 Target=524288 Hashed=10750
Internal Reservation=104857 External Reservation=0
Stolen Potential=-13308
Min Free=2032 Visible=524288
Available Paging File=128204582912
2010-06-18 11:25:01.77 spid52 Procedure Cache: TotalProcs=4 TotalPages=71 InUsePages=21 2010-06-18 11:25:01.77 spid52 Process physical/virtual memory pressure: 1/0 System physical memory pressure: 0 2010-06-18 11:25:01.77 spid52 Global Memory Objects:
Resource=718
Locks=719
SE Schema Mgr=2014
SQLCache=364
Replication=2
ServerGlobal=50
XPGlobal=2
Xact=133
SETLS=16
DatasetMemObjs=32
SubpDescPmos=16
SortTables=1524 2010-06-18 11:25:01.77 spid52 Query Memory Objects: Grants=0 Waiting=0 Maximum=23385 Available=23385 Limit=23385 2010-06-18 11:25:01.77 spid52 Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=24615 2010-06-18 11:25:01.77 spid52 Small Query Memory Objects: Grants=0 Waiting=0 Maximum=9169 Available=9169 Limit=9169 2010-06-18 11:25:01.77 spid52
Optimization Queue
Overall Memory = 3442507776 Target Memory = 215154688 Last Notification = STABLE Timeout = 6 Early Termination Factor = 5
2010-06-18 11:25:01.77 spid52
Small Gateway
Configured Units = 64 Available Units = 64 Acquires = 0
Waiters = 0 Threshold Factor = 380000 Threshold = 380000
2010-06-18 11:25:01.77 spid52
Medium Gateway
Configured Units = 16 Available Units = 16 Acquires = 0
Waiters = 0 Threshold Factor = 12 Threshold = -1
2010-06-18 11:25:01.77 spid52
Big Gateway
Configured Units = 1 Available Units = 1 Acquires = 0
Waiters = 0 Threshold Factor = 8 Threshold = -1
2010-06-18 11:25:01.77 spid52
MEMORYBROKER_FOR_CACHE
Allocations = 492494
Rate = 4455
Target Allocations = 341630
Future Allocations = 0
Last Notification = SHRINK 2010-06-18 11:25:01.77 spid52
MEMORYBROKER_FOR_STEAL
Allocations = 19036
Rate = 5
Target Allocations = 26264
Future Allocations = 0
Last Notification = STABLE 2010-06-18 11:25:01.77 spid52
MEMORYBROKER_FOR_RESERVE
Allocations = 1696
Rate = 295
Target Allocations = 26264
Future Allocations = 95290
Last Notification = STABLE 2010-06-18 11:25:01.77 spid52
Ludo
June 19, 2010 at 10:35 am
Hi,
The USERSTORE_SXC section in you log has the largest amount of memory: "SinglePage Allocator = 3909992 KB" (~3.7Gb).
It looks like large batch execution issue described in MS article: http://support.microsoft.com/kb/2001221
June 24, 2010 at 10:44 am
2010-06-24 09:58:57.56 spid449
Memory Manager
VM Reserved = 1523184 KB
VM Committed = 566320 KB
AWE Allocated = 50332416 KB
Reserved Memory = 1024 KB
Reserved Memory In Use = 0 KB 2010-06-24 09:58:57.56 spid449
Memory node Id = 0
VM Reserved = 1519024 KB
VM Committed = 562312 KB
AWE Allocated = 50332416 KB
SinglePage Allocator = 299856 KB
MultiPage Allocator = 37672 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLGENERAL (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 157600 KB
MultiPage Allocator = 12800 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLBUFFERPOOL (Total)
VM Reserved = 1324344 KB
VM Committed = 502112 KB
AWE Allocated = 50332416 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 13736 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLQUERYEXEC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2960 KB
MultiPage Allocator = 520 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLOPTIMIZER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5112 KB
MultiPage Allocator = 88 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLUTILITIES (Total)
VM Reserved = 120 KB
VM Committed = 120 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 10640 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLSTORENG (Total)
VM Reserved = 15808 KB
VM Committed = 15808 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8912 KB
MultiPage Allocator = 608 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLCONNECTIONPOOL (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5360 KB
MultiPage Allocator = 48 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLCLR (Total)
VM Reserved = 135808 KB
VM Committed = 3088 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 800 KB
MultiPage Allocator = 1232 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLSERVICEBROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 168 KB
MultiPage Allocator = 192 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLHTTP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SNI (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 600 KB
MultiPage Allocator = 48 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_FULLTEXT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLXP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_BHF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1104 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLQERESERVATIONS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 132224 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_HOST (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 200 KB
MultiPage Allocator = 208 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SOSNODE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 13232 KB
MultiPage Allocator = 8000 KB 2010-06-24 09:58:57.56 spid449
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 24 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_OBJCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5968 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_SQLCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1920 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_PHDR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2072 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_XPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 40 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_TEMPTABLES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 56 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_NOTIF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_VIEWDEFINITIONS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_XMLDBTYPE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_XMLDBELEMENT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_XMLDBATTRIBUTE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_STACKFRAMES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 8 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERTBLACS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 224 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERKEK (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERDSH (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERUSERCERTLOOKUP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERRSB (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERREADONLY (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_BROKERTO (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_EVENTS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_CLRPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
CACHESTORE_SYSTEMROWSET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 928 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
USERSTORE_SCHEMAMGR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 6136 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
USERSTORE_DBMETADATA (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1496 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
USERSTORE_TOKENPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 42360 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
USERSTORE_OBJPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 6528 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
USERSTORE_SXC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 184 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
OBJECTSTORE_LBSS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 416 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
OBJECTSTORE_SNI_PACKET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 18592 KB
MultiPage Allocator = 48 KB 2010-06-24 09:58:57.56 spid449
OBJECTSTORE_SERVICE_BROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 256 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449
OBJECTSTORE_LOCK_MANAGER (Total)
VM Reserved = 2048 KB
VM Committed = 2048 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5752 KB
MultiPage Allocator = 0 KB 2010-06-24 09:58:57.56 spid449 Buffer Distribution: Stolen=27978 Free=36017 Cached=11434
Database (clean)=5624026 Database (dirty)=591353
I/O=0, Latched=8 2010-06-24 09:58:57.56 spid449 Buffer Counts: Committed=6290816 Target=6290816 Hashed=6215401
Internal Reservation=19456 External Reservation=14611
Stolen Potential=38439
Min Free=2016 Visible=97280
Available Paging File=83321585664
2010-06-24 09:58:57.56 spid449 Procedure Cache: TotalProcs=65 TotalPages=1250 InUsePages=123 2010-06-24 09:58:57.56 spid449 Process physical/virtual memory pressure: 1/0 System physical memory pressure: 0 2010-06-24 09:58:57.56 spid449 Global Memory Objects:
Resource= 785
Locks= 722
SE Schema Mgr= 749
SQLCache= 19172
Replication= 2
ServerGlobal= 28
XPGlobal= 2
Xact= 373
SETLS= 16
DatasetMemObjs= 32
SubpDescPmos= 26
SortTables= 2 2010-06-24 09:58:57.56 spid449 Query Memory Objects: Grants=2 Waiting=0 Maximum=22900 Available=6372 Limit=22900 2010-06-24 09:58:57.56 spid449 Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=24105 2010-06-24 09:58:57.56 spid449 Small Query Memory Objects: Grants=0 Waiting=0 Maximum=1473 Available=1473 Limit=1473 2010-06-24 09:58:57.56 spid449
Optimization Queue
Overall Memory = 638779392 Target Memory = 171081728 Last Notification = SHRINK Timeout = 6 Early Termination Factor = 5
2010-06-24 09:58:57.56 spid449
Small Gateway
Configured Units = 32 Available Units = 30 Acquires = 2
Waiters = 0 Threshold Factor = 250000 Threshold = 250000
2010-06-24 09:58:57.56 spid449
Medium Gateway
Configured Units = 8 Available Units = 8 Acquires = 0
Waiters = 0 Threshold Factor = 12 Threshold = 7128405
2010-06-24 09:58:57.56 spid449
Big Gateway
Configured Units = 1 Available Units = 1 Acquires = 0
Waiters = 0 Threshold Factor = 8 Threshold = -1
2010-06-24 09:58:57.56 spid449
MEMORYBROKER_FOR_CACHE
Allocations = 46309
Rate = -265
Target Allocations = 31371
Future Allocations = 0
Last Notification = SHRINK 2010-06-24 09:58:57.56 spid449
MEMORYBROKER_FOR_STEAL
Allocations = 25835
Rate = 4817
Target Allocations = 20884
Future Allocations = 0
Last Notification = SHRINK 2010-06-24 09:58:57.56 spid449
MEMORYBROKER_FOR_RESERVE
Allocations = 27776
Rate = -88
Target Allocations = 25719
Future Allocations = 37749
Last Notification = SHRINK
I thought that this could be because of MTL pressure as i do not see any BPOOL pressure as per the output of DBCC memory status.
Please comment
Regards,
Mani
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply