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.
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:
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.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Time: 10:41:12 AM
Computer: (removed by poster)
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)
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:
Any suggestions or further troubleshooting ideas are appreciated.
- 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.
Last edited by ReadySetStop; 03-30-09 at 14:25.
Data Integrity? Yeah, I've heard of that...