Post reply

SQL 2K out of memory

  • August 18, 2005 at 4:22 am

    #363467

    Err, has anyone encountered this:

    I have a server running SBS 2003 and SQL 2K with 1 GB ram.  When I upgraded the ram to a total of 3 GB and run a DTS wizard or similair program I get:

    Server: Msg 7399, Level 16, State 1, Procedure DW4R_SalesOrders_Sync, Line 61

    OLE DB provider 'MSDASQL' reported an error. The provider ran out of memory.

     

    I've adjusted the running memory configs in SQL, applied SQL2KSP4, killed unneccesary processes and booted all users off the box, to no avail.  What next? Stand on the head chanting please work?

    If I remove the new memory I am back up and running.  Could the new ram be faulty or am I missing a crucial setting in SQL EM?

     

    Michael Gilchrist
    Database Specialist
    There are 10 types of people in the world, those who understand binary and those that don't. 😀

  • August 18, 2005 at 8:37 am

    #583076

    Sounds to me like defective RAM, especially if the machine returns to normal again after removing it.  Our guys have a tester in house but if you don't have one, a local shop may be able to test it for you for little or no charge.  But I'd be willing to bet that's your problem. 

    My hovercraft is full of eels.

  • August 18, 2005 at 8:45 am

    #583092

    Thanks sswords. This machine is live so any changes are quite difficult. I will try other ram and let you know.

    Michael Gilchrist
    Database Specialist
    There are 10 types of people in the world, those who understand binary and those that don't. 😀

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

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