Post reply

Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 327680

  • March 17, 2011 at 7:14 am

    #236999

    My environment is SQL 2008 Standard x86 with SP2 running on Server 2008 Standard, with 4Gb ram and AWE enabled. I also have -g1024 set on startup.

    I am getting the following error in the SQL error log:

    Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 327680

    Then later:

    Error: 701, Severity: 17, State: 123.

    There is insufficient system memory in resource pool 'internal' to run this query.

    Which are repeated until the server eventually stops processing queries.

    I strongly suspect that the issue is to do with linked servers as I am linking to a Sybase ASE 15 server using the "Microsoft OLEDB Provider for ODBC Drivers" provider. How can I prove whether or not this is the case and/or troubleshoot this issue?

    Edit: Relevant entries from the SQL error log are now attached.

    Thanks.

  • June 28, 2011 at 6:24 pm

    #1345596

    Do you have any resolution on this issue? We are running into exact same situation. Any feedback is greatly appreciated.

    Thanks,

    Ritesh

  • June 29, 2011 at 1:17 am

    #1345682

    Hi Ritesh,

    Yes, we think it is now resolved. It seems that we were pulling too much data from a Sybase database over a linked server, using the OPENQUERY command. We now force the where clause into the sybase query so that much less data is transferred and don't have the issue anymore.

    Craig

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

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