Solved

Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 65536

Posted on 2010-11-29
3
1,436 Views
Last Modified: 2012-05-10
I have 2005 SQL server 64 bit (Microsoft windows server 2003 R2). It has 8GB of ram.

There is the following entry in the error log:
2010-11-25 08:32:57.37 spid314      Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 65536
2010-11-25 08:32:57.43 spid314    
Memory Manager
      VM Reserved = 8615664 KB
      VM Committed = 6711952 KB
      AWE Allocated = 0 KB
      Reserved Memory = 1024 KB
      Reserved Memory In Use = 0 KB

2010-11-25 08:32:57.43 spid314    
Memory node Id = 0
      VM Reserved = 8609904 KB
      VM Committed = 6706280 KB
      AWE Allocated = 0 KB
      SinglePage Allocator = 1468560 KB
      MultiPage Allocator = 52392 KB

2010-11-25 08:32:57.43 spid314    
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 = 16632 KB
      MultiPage Allocator = 5912 KB

2010-11-25 08:32:57.43 spid314    
MEMORYCLERK_SQLBUFFERPOOL (Total)
      VM Reserved = 8413184 KB
      VM Committed = 6512752 KB
      AWE Allocated = 0 KB
      SM Reserved = 0 KB
      SM Committed = 0 KB
      SinglePage Allocator = 0 KB
      MultiPage Allocator = 8 KB

2010-11-25 08:32:57.43 spid314    
MEMORYCLERK_SQLQUERYEXEC (Total)
      VM Reserved = 0 KB ..........................................


I checked the perfmon counters. Total Server Memory(Avg is 6114728, rougly 6 gb of ram) and Target Server Memory(Avg is 6253704, rougly 6gb of ram).

I dont know how this 'Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 65536' error is occuring. Your help is appreciated.
0
Comment
Question by:itbossman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
ggupta7 earned 250 total points
ID: 34232323
You are most likely suffering from look of MemtoLeave or VAS memory. We have
it here because of CLR, linked servers and using Red Gate SQLBackup that
runs in this space. I would suggest that you make sure that your page file
is 1.5 times your RAM (18Gb in your case) as this helps to alleiviate the
pressure. Albo look in BOL for Using the SQL Server Service Startup Options
and look at the -g parameter.
Somemore Info:

Microsoft SQL Server 2005 - 9.00.3353.00 (Intel X86)
    Aug 14 2009 18:07:44
    Copyright (c) 1988-2005 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I realised that it has 64-bit processor with 32-bit Windows (and 32-bit
SQLServer)







or



http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/16/how-to-find-who-is-using-eating-up-the-virtual-address-space-on-your-sql-server.aspx


or



http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/2ad95cf8-54a3-42fa-9e16-befce8fbd1b5/

0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 250 total points
ID: 34248434
How often has this error occurred?  The problem is that your MTL/VAS memory is either too fragmented or there is no more available memory.  SQL Server tried to allocate 65536 of memory but there was no contiguous memory of that size or greater.

Look at the URLs that ggupta7 posted.

Are you running SQL 2005 SP3?  If not, I'd recommend applying these updates.

Also, here is what microsoft support recommended to me for a case I opened with them.

1. Turn on trace flags 8004 and 2551.  When the memory issue occurs a memory dump file will be written.  Microsoft support can read this dump file and tell you what was asking for memory.

DBCC TRACEON(8004,2551,-1)
GO

DBCC TRACEOFF(8004,2551,-1)
GO

2. Run DBCC MEMORYSTATUS during the time of the issue.
You can create a job to run this every 10 or 15 min .

3. Enable –g512.  This increases the amount of MTL/VAS memory.  However for 64 bit you shouldn't need to do this.

4. Move 3rd Party Components Out of Process.

5. Run this Query   in QA  or you can have a job for this highlighed Query to run every one min.
while(1=1)
begin
select top 10 getdate() as [date time], count(*) as entries,
            type,
            sum(single_pages_kb) as sum_single_pages_kb ,
            sum( multi_pages_kb) as sum_multi_pages_kb,
            sum(virtual_memory_committed_kb )as sum_irtual_memory_committed_kb,
            sum(awe_allocated_kb) as sum_awe_allocated_kb,
            sum(shared_memory_committed_kb)as sum_shared_memory_committed_kb
from   sys.dm_os_memory_clerks
group by   type
waitfor delay '00:01:00'
end
0
 

Author Closing Comment

by:itbossman
ID: 34654492
thanks. i will take a look
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Windows Server 2003 Policy Preventing Updates 6 57
SBS 2003 RWW Login 3 50
ISDATE() not working properly on my table? Any suggestions. 7 46
How can I use this function? 3 33
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question