Out of Memory Errors: FAIL_VIRTUAL_RESERVE 1048576

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Out of Memory Errors: FAIL_VIRTUAL_RESERVE 1048576

Author

Topic

bogey
Posting Yak Master

166 Posts

Posted - 2009-08-04 : 11:17:20

Over the weekend we started receiving memory errors:
I'm running windows 2003 with 4Gb of Memory. SQL Server is only Allocated 2Gb. Here is the output of the Sql Server Log File:

08/01/2009 18:00:08,spid76,Unknown,MEMORYBROKER_FOR_RESERVE <nl/> Allocations = 128 <nl/> Rate = 2 <nl/> Target Allocations = 162351 <nl/> Future Allocations = 36145 <nl/> Last Notification = GROW
08/01/2009 18:00:08,spid76,Unknown,MEMORYBROKER_FOR_STEAL <nl/> Allocations = 1552 <nl/> Rate = -9 <nl/> Target Allocations = 155215 <nl/> Future Allocations = 0 <nl/> Last Notification = GROW
08/01/2009 18:00:08,spid76,Unknown,MEMORYBROKER_FOR_CACHE <nl/> Allocations = 1079 <nl/> Rate = 8 <nl/> Target Allocations = 154759 <nl/> Future Allocations = 0 <nl/> Last Notification = GROW
08/01/2009 18:00:08,spid76,Unknown,Big Gateway <nl/> Configured Units = 1 Available Units = 1 Acquires = 0 <nl/> Waiters = 0 Threshold Factor = 8 Threshold = -1
08/01/2009 18:00:08,spid76,Unknown,Medium Gateway <nl/> Configured Units = 4 Available Units = 4 Acquires = 0 <nl/> Waiters = 0 Threshold Factor = 12 Threshold = -1
08/01/2009 18:00:08,spid76,Unknown,Small Gateway <nl/> Configured Units = 16 Available Units = 16 Acquires = 0 <nl/> Waiters = 0 Threshold Factor = 250000 Threshold = 250000
08/01/2009 18:00:08,spid76,Unknown,Optimization Queue <nl/> Overall Memory = 1329979392 Target Memory = 1271521280 Last Notification = GROW Timeout = 6 Early Termination Factor = 5
08/01/2009 18:00:08,spid76,Unknown,Small Query Memory Objects: Grants=0 Waiting=0 Maximum=7609 Available=7609 Limit=7609
08/01/2009 18:00:08,spid76,Unknown,Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=152190
08/01/2009 18:00:08,spid76,Unknown,Query Memory Objects: Grants=1 Waiting=0 Maximum=144581 Available=144453 Limit=144581
08/01/2009 18:00:08,spid76,Unknown,Global Memory Objects: <nl/> Resource= 232<nl/> Locks= 166<nl/> SE Schema Mgr= 508<nl/> SQLCache= 46<nl/> Replication= 2<nl/> ServerGlobal= 27<nl/> XPGlobal= 2<nl/> Xact= 36<nl/> SETLS= 4<nl/> DatasetMemObjs= 8<nl/> SubpDescPmos= 4<nl/> SortTables= 2
08/01/2009 18:00:08,spid76,Unknown,Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
08/01/2009 18:00:08,spid76,Unknown,Procedure Cache: TotalProcs=3 TotalPages=81 InUsePages=38
08/01/2009 18:00:08,spid76,Unknown,Buffer Counts: Committed=202576 Target=202576 Hashed=199513<nl/> Internal Reservation=40515 External Reservation=125<nl/> Stolen Potential=189708<nl/> Min Free=128 Visible=202576<nl/> Available Paging File=8239435776
08/01/2009 18:00:08,spid76,Unknown,Buffer Distribution: Stolen=1560 Free=449 Cached=1054<nl/> Database (clean)=185206 Database (dirty)=14304<nl/> I/O=1<c/> Latched=2
08/01/2009 18:00:08,spid76,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) <nl/> VM Reserved = 4096 KB <nl/> VM Committed = 4096 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 1304 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,OBJECTSTORE_SERVICE_BROKER (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 256 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,OBJECTSTORE_SNI_PACKET (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 624 KB<nl/> MultiPage Allocator = 128 KB
08/01/2009 18:00:08,spid76,Unknown,OBJECTSTORE_LBSS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 64 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,USERSTORE_SXC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,USERSTORE_OBJPERM (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 672 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,USERSTORE_TOKENPERM (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 176 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,USERSTORE_DBMETADATA (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 304 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,USERSTORE_SCHEMAMGR (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 3944 KB<nl/> MultiPage Allocator = 128 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_SYSTEMROWSET (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 120 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_EVENTS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERTO (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERREADONLY (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 32 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERRSB (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERDSH (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERKEK (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_BROKERTBLACS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 160 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_STACKFRAMES (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 0 KB<nl/> MultiPage Allocator = 8 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_XMLDBATTRIBUTE (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_XMLDBELEMENT (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_XMLDBTYPE (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_VIEWDEFINITIONS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_NOTIF (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_TEMPTABLES (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_XPROC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_PHDR (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_SQLCP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 344 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,CACHESTORE_OBJCP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 280 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 40 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SOSNODE (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 4648 KB<nl/> MultiPage Allocator = 6400 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_HOST (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 24 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLQERESERVATIONS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 1024 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLXP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_FULLTEXT (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 16 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SNI (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 48 KB<nl/> MultiPage Allocator = 16 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLHTTP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLSERVICEBROKER (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 144 KB<nl/> MultiPage Allocator = 192 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLCLR (Total) <nl/> VM Reserved = 101376 KB <nl/> VM Committed = 6588 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 696 KB<nl/> MultiPage Allocator = 1048 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 512 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLSTORENG (Total) <nl/> VM Reserved = 9664 KB <nl/> VM Committed = 9664 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 2176 KB<nl/> MultiPage Allocator = 208 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLUTILITIES (Total) <nl/> VM Reserved = 8568 KB <nl/> VM Committed = 8568 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 352 KB<nl/> MultiPage Allocator = 12080 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLOPTIMIZER (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 1448 KB<nl/> MultiPage Allocator = 72 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLQUERYEXEC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 8 KB<nl/> MultiPage Allocator = 0 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLBUFFERPOOL (Total) <nl/> VM Reserved = 1636668 KB <nl/> VM Committed = 1636668 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 0 KB<nl/> MultiPage Allocator = 400 KB
08/01/2009 18:00:08,spid76,Unknown,MEMORYCLERK_SQLGENERAL (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB<nl/> SinglePage Allocator = 2264 KB<nl/> MultiPage Allocator = 2824 KB
08/01/2009 18:00:08,spid76,Unknown,Memory node Id = 0 <nl/> VM Reserved = 1786996 KB <nl/> VM Committed = 1689848 KB <nl/> AWE Allocated = 0 KB <nl/> SinglePage Allocator = 20880 KB<nl/> MultiPage Allocator = 23640 KB
08/01/2009 18:00:08,spid76,Unknown,Memory Manager <nl/> VM Reserved = 1791156 KB<nl/> VM Committed = 1693856 KB <nl/> AWE Allocated = 0 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB
08/01/2009 18:00:08,spid76,Unknown,Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576

paultinnz
Starting Member

2 Posts

Posted - 2009-10-16 : 01:55:21

Hi Bogey,

Did you ever figure out what caused your problem

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-10-16 : 02:23:43

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/5d40d836-6faf-440e-8533-d60099671d24

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources