none
Fix for "Failed Virtual Allocate Bytes" error? RRS feed

  • Question

  • Hi all,

     

    We have a SQL Server 2005 database hosting the BlackBerry application. Once in a while the CPU usage for this server will go through the roof and eventually cause the database to shutdown. Reviewing the SQL Server error log there is a “Failed Virtual Allocate Bytes “ error proceeding many “Error 701. There is insufficient system memory to run this query.“  

     

    According to the status section of this article http://support.microsoft.com/default.aspx?scid=kb;en-us;959007  è “This problem was first corrected in SQL Server 2005 Service Pack 3. “

     

    Our SQL Server is running on 2005 SP3 (9.00.4035.00). Not sure if http://support.microsoft.com/kb/959195 (Cumulative update package 1 for SQL Server 2005 Service Pack 3) is the fix for this issue since I didn’t notice anything that may be related to this. 

     

    Looking for someone who may be able to confirm the service pack version I need to apply for fixing this problem. The executable I used was “SQLServer2005SP3-KB955706-x86-ENU.exe”

     

    -- Thanks in advance for any information you may provide

     

     

    --

     

    SQL server Error log:

     

     

    :

    2009-03-03 10:27:39.90 spid54       Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824

    2009-03-03 10:27:39.92 spid54     

    Memory Manager

                    VM Reserved = 1697192 KB

                    VM Committed = 1693400 KB

                    AWE Allocated = 0 KB

                    Reserved Memory = 1024 KB

                    Reserved Memory In Use = 0 KB

    2009-03-03 10:27:39.92 spid54     

    Memory node Id = 0

                    VM Reserved = 1693032 KB

                    VM Committed = 1689392 KB

                    AWE Allocated = 0 KB

                    SinglePage Allocator = 33160 KB

                    MultiPage Allocator = 22824 KB

    2009-03-03 10:27:39.92 spid54     

    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 = 2496 KB

                    MultiPage Allocator = 3960 KB

     

    :

    :

     

                    Last Notification = GROW

    2009-03-03 10:27:39.93 spid54     

    MEMORYBROKER_FOR_RESERVE

                    Allocations = 128

                    Rate = 6

                    Target Allocations = 164160

                    Future Allocations = 36551

                    Last Notification = GROW

    2009-03-03 10:27:39.94 spid54      Error: 701, Severity: 17, State: 123.

    2009-03-03 10:27:39.94 spid54      There is insufficient system memory to run this query.

    :

    Tuesday, March 3, 2009 9:16 PM