Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142

    Exclamation Unanswered: SQL 2000 consumes all available memory on startup.

    Morning, guys and gals. Hoping someone can toss me a clue, here...

    Here's my config:
    Running SQL 2000 SP4 (2039) on Win 2003 Server R2 SP2.
    3.0 GB ram, dual 3GHz processors, ~500GB disk over 4 volumes.
    SQL is configured to use a max of 2049MB of ram on this box, no minimum. No other performance configurations have been done on this server.

    The problem:
    Last Monday when the server was restarted, the SQL services started up fine, but proceeded to start grabbing as much memory as they could, and ended up consuming the entire 2.0 GB allocated to them in about 5 minutes. There it stayed until we started getting this:

    Code:
    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 17052
    Date:  3/30/2009
    Time:  10:41:12 AM
    User:  N/A
    Computer: (removed by poster)
    Description:
    Error: 17803, Severity: 20, State: 12
    Insufficient memory available.
    For more information, see Help and Support Center at Events and Errors Message Center: Basic Search.
    Data: (removed by poster)
    We then restarted the services on Wednesday afternoon, and the errors went away for a couple days. Weekend reboots come around again, and as of this morning we're back to the errors. We have not yet restarted the services.

    Update: 2009.03.30 - 12:45 PM - Restarted the services and memory climbed to about 1.7 GB and is holding there. So I'm thinking now that there's got to be something on startup that's doing this, but I have no idea what.

    What I've checked:
    • No other apps run on this box.
    • No other processes are consuming abnormal amounts of memory.
    • There have been no recent app or patch installs on this box.
    • There are no startup stored procs on this server.
    • No jobs run on startup and there are no idle condition jobs either.
    • Processor and disk usage is normal for that server. No change there.
    Any suggestions or further troubleshooting ideas are appreciated.

    Thanks.
    -d.
    Last edited by ReadySetStop; 03-30-09 at 14:25.
    David Maxwell
    Data Integrity? Yeah, I've heard of that...

  2. #2
    Join Date
    Apr 2009
    Posts
    2
    From reading the content u posted here,
    i can say tht have u enable \pae or 3 gb switch in the boot ini file
    check how much memory sql has been allocated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •