Post reply

Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576 - Error Message

  • July 7, 2011 at 5:59 pm

    #150316

    Hi Guys,

    Can you guys assist me with this error message please.

    Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576

    Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576

    Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576

    then followed by these

    Downgrading backup log buffers from 1024K to 64K

    It started happening 3 days ago on our server.

    We are running SQL Server 2005 sp2 standard edition on Win Server 2003

    Thanks.

    Sun

  • July 7, 2011 at 7:23 pm

    #1350118

    Hi Guys,

    In addition to the above, we are getting the following message when a transaction log back up job is running.

  • July 13, 2011 at 9:04 am

    #1352219

    32-bit Windows right?

    This happens when your server runs out of MemToLeave memory area. It's related to limitations with the Virtual Address Space in 32-bit windows and the only cure is to restart the instance. You can try increasing your MemToLeave setting to something higher but if you're doing a lot of Linked Server or SQLCLR activities it may be time to think about upgrading to a 64-bit operating system.

    Here is a good article detailing VAS and MemToLeave:

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply